Middlebury, Connecticut, United States
Innovation Application Developer and Analyst with 19+ years IT professional experience in SQL Server Management Studio SSMS, Oracle, ETL, SSRS, SSIS, Business Intelligence, UiPath, GitHub, Transact SQL, Data Warehouse, Data Mart, Star Schemas Advanced Access /Excel, Object-Oriented Programming, SharePoint, UNIX. Practical hands-on experience to build SQL data warehouse and automation reports. Created, analyzed, and supported large and complex SQL data warehouse with the full Software Development Life Cycle (SDLC) in Healthcare, Banking, Waste Management, Finance, Accounting, Investment, Commercial Lending industry environment. A hardworking and self-motivated professional be able to work independently, team settings, quickly learn new technology, and work in a high paced environment. TECHNICAL SKILLS •Business Intelligence, GitHub, Microsoft SQL Server Management Studio 2014/2016/2018 (SSMS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio Enterprise 2022, Data Warehouse, Azure, SQL Server Integration Services (SSIS), Microsoft Team Foundation Server (TFS), Oracle11g, T-SQL, Schemas, UiPath Robot, Toad Oracle, Tableau, Power BI, DB2, Cognos, Agile, Advanced Access/Excel, Visio, SharePoint •Programming: SQL, My SQL, Object-Oriented Design and Programming, Java, Java Servlets and JSP, C++, C, C#, ASP.Net, VBA, HTML, CSS, XML, Unix Shell Scripts, Visual Basic •MBA background in Healthcare, Banking, Finance, Investment, Accounting, Informatics, Waste Management with excellent reporting, analytical, mathematical, and creative problem-solving skills
Applications Developer II •Design and create Provider Date Warehouse, Data Mart, Star Schemas, and SQL Server Reporting Services (SSRS); design, build, execute complex nested SQL queries to support Provider team •Build SSIS package to extract the data from other DB sources, ETL transform the data according to the business requirement and load into Relational DB or Network Driver files •Connect to Configuration Management with Microsoft Team Foundation Server, GitHub, NDB, and Source Control System to collaborate the code, track changes, deploy the new changes in PROD •Archive Titan and Midas Claim large data into Azure Date Warehouse, develop store procedures to remove one-year older data from SQL Server DB; experience with database performance index and tuning •Provided DBA support, troubleshoot, and routine maintenance for multiple large databases in production, development and test environments for various types of database and reporting •Build data warehouse data modeling, relational databases, database design and SQL Development; define and implement ETL tool configuration •Develop Integration Service Catalogs and SSIS project package, and build SQL Server Agent Jobs to automation process. Provide scripting and execution of Extraction, Transformation, and Loading (ETL) scripts for data migration to support moving data to a new platform •Communicate business users about the requirements and iteratively design BI visualizations for initial concepts and prototypes that can be presented to customers for the feedback •Develop through Agile software development methodologies, create project documentation, work in a matrix team environment with distributed responsibility across different teams, plus Off-shore teams •Create daily, weekly, monthly, quarterly detailed reports, and perform data analysis for PTBS Automation, OnBase, Care Delivery Operations, NDB team, Cosmos team
Consultant
•Responsible for all aspects of design, create, update, maintain and deploy the store procedure, query and report with Microsoft SQL Management Server (SSMS) utilizing SQL Reporting Services (SSRS)
•Worked independently to develop the complex large scale data models of system in SQL Server management Studio and SQL Server Reporting Service, code and test reports based on the user requirement or specifications •Developed Automating reports with SQL Management Server (SSMS), MS SQL Reporting Services (SSRS), Business Intelligence, SQL 2008 Analysis Service (SSAS), SQL Server Integration Services (SSIS), Microsoft TFS, MS Dynamics Great Plains, ETL, Data Warehouse, Advanced Access/Excel •Worked with each department manager to manipulate the data, analyze the data, create report format, and generate automatically report; work with account/finance department to capture Sears/Kmart 10 million sales data to automate the financial reports •Experience with Multidimensional Database, OLAP, Cube tools, Excel pivot tables, deriving data from SQL Server data source and deployed to SharePoint sites •Experience with Data Migration, Upgrade and Conversion from 2005 SSRS to 2008 SSRS, •Provides support to team by collecting, analyzing the data and report the results; collaborates with various function groups such as Accounting, Finance, Marketing to achieve business results •Contacted to the end user about the project accurate and timely project status, issues, and scope changes
•Designed, tested, debugged and monitored Commercial Finance Database Reporting System in SQL Server, Data Warehouse, SSRS, Access, Excel, Visual Basic •Created, developed, implemented, coded and tested complex data models and logical database design of Retail Banking Consolidate Error Database and Reporting System, Leadership Scorecard and Dashboard , Branch Turnover, Cash Over Short , Staffing Age of Requisitions, and Job Time to Fill •Administrated Webster Bank retail banking website •Managed Database Security and Reporting Permissions. Created and assigned appropriate roles and privileges to users depending on the user activity. Developed and analyzed SQL tables with integrity constraints and optimize queries to create business reports, Crystal Report •Familiar with SQL query tools, Advanced MS Access, Oracle, SQL Server and Oracle database in UNIX for web development and maintenance of Client-Server systems for financial business reporting • Developed data model diagram and reporting system based on Entity Relation Diagram, Structure Chart, Process Flow Diagram and business reporting for Client Server Development projects in commercial loan ranging from $5,000 to $2,500,000, including commercial revolving line of credit, commercial time loan, commercial term loan, and mortgage loan, etc •Analyzed commercial loan credit reports, created financial debt repayment and cash flow forecasting models and reporting to determine Corporate/Personal Debt Service Requirement, Corporate/Global Debt Service Coverage Ratio(DSCR), collateral analyst, loan to value(LTV), and deal profitability