Summary:

• Over 7 years IT experience in Design, Development, Tuning and Maintenance of client/server Database, and in various phases of software development cycle using tools of MS SQL Server 2012/2008R2/2008/2005.
• Experienced in implementing Business Intelligence Solutions for Enterprise Decision Support solutions using SSIS, create server side reporting solutions using SSRS, and data analysis solutions using SSAS.
• Expertise and experience in designing, and developing RDBMS, whose structure included Schemas, Tables, views and Indexes. Used indexes for faster data manipulation and constraints for data integrity.
• Expert in SQL server diagnostic tools such as using SQL profiler, Index Tuning, and Database Engine Tuning Advisor to optimize queries and tune performance.
• Experienced in creating configuration files, Logging, Error Handling using Event Handlers in SSIS.
• Expert in performance tuning of SSIS packages using row transformations and parallelism.
• Experienced in data Extraction, Transformation, and Loading using various tools such as SQL Server Integration Services SSIS , Bulk insert and Bulk Copy Program utility.
• Well versed with creating Dynamic SSIS packages, using containers and variables, configuring the packages, and scheduling the packages.
• Experience in creating sub-reports, cascading parameters reports, drill-through report, ad-hoc report, chart report, and dynamic matrix reports. Deployed reports across test, development and production environments.
• Extensively developed financial reports and implemented security measures on Share point.
• Experienced in creating interactive platforms using Power view and Power map in Excel using various data sources like SQL Server, MS Access, and SSAS cubes.
• Vast experience in creating and providing management reporting, internal dashboards and scorecards that showed key performance indicators KPI on performance point services.
• Experienced in developing and deploying cubes from fact and dimension tables for star/snowflake schema using SSAS.
• Well versed with Kimball's theory and how to normalize in OLTP environment and de-normalize in OLAP environment as per business rules.
• Experienced in providing migration solutions to SQL Server from MySQL, Oracle and DB2 using SQL Migration Assistant.
• Implemented agile, waterfall, and Verification Validation developmental methodologies depending on customer needs.
• Proficient in Alteryx ETL and analytical platform using either preexisting modules or customizing applications to the current task and business rules.
• Skilled at solving challenges in a methodical manner and analyzing current issues to envision creative solutions. Demonstrate intellectual curiosity thus seamlessly learn new technology.

Skillset:

MS SQL Server 2012/2008R2/2008/2005, MS SQL Server Integration Services SSIS , MS SQL Reporting Services SSRS , MS SQL Analysis Services SSAS , Alteryx 8.0, MS SQL Profiler, MS Access 97/2000, Microsoft Visio 2000/2003/2007, Microsoft office, Windows 2000 Server, Windows XP, SharePoint, VB script, Oracle 10.0, Java, Performance Point Services, Office 365, Power BI, Erwin

Projects Summary:

Confidential

ETL Developer/ BI Developer

Responsibilities

• Developed ETL packages to import data from heterogeneous sources and loaded to SQL Server.
• Retrieved data from client OLTP, processed and loaded data into operational data store.
• Standardized data such as addresses from vendors, for mailability compliance to NCOA, and solving proactive and reactive performance issues such as match back.
• Collaborated with team members to streamline and continuously improve reporting solutions. Generated visualization adhoc reports using Alteryx and SSRS.
• Developed database performance solutions and optimization methodology by incorporating Regex tools in Legacy systems. Investigated and recommended other opportunities to improve processes.
• Executed daily, weekly and monthly reports, with pivot tables, and provided analytical support and expertise as it pertained to functional data.
• Worked with production team to identify ideal time, and automated production processes with respective alerts.
• Researched data discrepancies and took corrective action hence improving performance and decision making.
• Wrote complex SQL queries, modified stored procedures, and used indexed views to efficiently retrieve data from the database
• Migrated dts packages and incorporated script component to produce required results.
• Created data mappings, and migrated the mappings from testing to production.
• Designed and presented Macro application to both technical and nontechnical personnel.
• Documented and maintained technical instructions for new packages developed.

Environment: MS SQL Server 2012, SSRS, Visual Studio 2010, Excel, Alteryx, Windows Enterprise Manager, Teradata, VB.Net

Confidential

MS SQL Server/BI Developer

Responsibilities

• Developed income statement, cash flow statements and balance sheet reports on dashboard to enable drill through to core details.
• Involved in designing and deploying cubes in SSAS environment using snowflake and star schema designs for operational data.
• Implemented filters, scorecards, charts on dashboard reports on Performance point for analytical and aesthetic purposes.
• Investigated root cause analysis for favorable and unfavorable trends, and provided timely resolutions.
• Developed multidimensional database and OLAP cube using SSAS that stored and maintained the data. Deployed cubes and verified result on browser.
• Set up template for predictive modeling and financial forecasting models.
• Generated ad-hoc reports, maintained and scheduled Customer Relationship Management CRM reports. Notified managers and distributed reports through subscriptions.
• Successfully deployed reports on Share point and implemented security measures by assigning permissions.
• Generated parameterized queries stored procedures for generating tabular reports using global variables, expressions, functions, and subtotals while ensuring optimal report performance in SSRS.
• Developed SSIS packages to import data from various sources and load to operational data store.
• Used table and index partitioning to enhance query performance.

Environment: MS SQL Server 2012, SSRS, SSIS, Visual Studio 2010, Excel, Alteryx 8.0,

Confidential

MS SQL Developer/BI Developer

Responsibilities

• Used SQL profiler to trace slow running queries and server activity. Incorporated use of database engine tuning and index tuning to optimize queries.
• Designed data maps and data model created mappings using Data Conversion, Derived Column, Conditional Split, Multicast, and Union.
• Extracted data from heterogeneous sources using SSIS cleansed it using Exact/fuzzy lookup and standardized it for central management system.
• Involved in User Acceptance Testing to ensure project had addressed the clients requirements and needs.
• Use bulk insert task and fast parse option to optimize SSIS packages.
• Monitored and kept track of error logs from logging providers in SSIS.
• Supported software developers with using scrum methodology for automating claim filing.
• Designed standards for the database tables, columns, procedures and views for claim adjusters database system
• Use control flow elements like for each loop and sequence container, execute SQL task, execute process task, execute package task, send mail task using MS SQL Integration Services SSIS .
• Implemented slowly changing dimension up to type 2 to keep history of customer information.
• Enabled data viewers in development environment to verify results and ensure transformations were effective.
• Maintained Jobs, Alerts, Subscriptions, and schedules of SSIS Packages to run as per required by the priority given by manager.
• Loaded packages from the staging table to standardized table in SQL Server 2008R2.
• Scripted Transact SQL T-SQL queries and used SQL Server Constraint Primary Key, Foreign Key, Default, Checks and Unique .
• Enforced ACID on database transactions to ensure durability.
• Created pivot table and charts in Excel to complement loss and premium reserve actuarial analysis.
• Worked on SSRS reports for ETL processes and business requirements, deployed and scheduling them.

Environment: MS SQL Server 2008R2, TSQL, MS SQL Server Integration Services, MS SQL Server Reporting SSRS , Visual Studio 2005, MS Excel, MS Access

Confidential

MS SQL Server/BI Developer

Responsibilities

• Extracted data for reporting and analysis using SQL Server 2008R2 database management system.
• Created cascading parameterized and sub reports using SSRS for hospitals depending on department.
• Authored very detailed reports focusing on specific report server using report design formatting, outputs such as report layout, margins, color schemes, font selection, and chart selection using expressions as needed.
• Involved in requirement analysis, design, and implementation phase of V-model software development life cycle process.
• Integrated physician office documents into hospital database.
• Architected and implemented physical database models using MS Visio for physician office client.
• Migrated data from Oracle, Access, stand-alone Excel files to a centralized SQL server using SSIS and SQL Server Migration Assistant.
• Deployed the packages on staging and production environment by copying the deployment folder into a target machine and proceeding to run the package installation wizard.
• Implemented dynamic SSIS package that handled variable connection strings.
• Deployed patient report to a report server using report service configuration manager and created individual subscription for patient appointment reminder by enabling physical Scheduled events and report deliver.
• Wrote technical document for each successful package in order to assist the users and future developers.
• Modified existing stored procedures to conform to model changes in SQL Server 2008R2.
• Created job audit in SQL Server Management studio based on the client's policy to account for packages that has been executed in the SSIS environment.
• Worked with script component to write codes in VB.Net to implement data initialization settings.

Environment: MS SQL Server 2008R2, T-SQL, SSIS, SSRS, SSAS, VB.Net, C , SQL Server Migration Assistant

Confidential

MS SQL Server Development/BI Developer

Responsibilities

• Created logical and physical data models for requirements from different departments, translated the requirements into high level ETL design.
• Generated platform to complete cost benefit analysis of contracting clinical trials.
• Used Bulk copy program BCP to import large amounts of data into SQL Server databases.
• Generated tabular, chart, ad-hoc and sub reports for Phase I through IV for clinical trials depending on business needs.
• Developed a dimensional database and OLAP cube using SSAS for analysis on equipment maintenance and productivity of products.
• Implemented complex processes involving diverse data sources and transformations. Created packages to import data from multiple sources to the staging environment, and export data from the staging environment to the data warehouse using SSIS.
• Developed and used complex query statements like sub queries, correlated queries, CASE functions to manipulate the data depending on the criteria.
• Performed data cleansing and massaging using various transformations components in SSIS and cleared duplicate data using dataflow components.
• Configured the package to send email messages if tasks in the package workflow succeed or fail, or send messages in response to an event that the package raises at run time.
• Created variables and configuration files to make the package more dynamic and schedule jobs to run automatically using SQL server agent.

Environment: MS SQL Server 2005/2008, Visual Studio, OLAP, Windows XP, Windows Vista, SSIS, SSRS, SSAS