PROFESSIONAL SUMMARY:

• An SQL developer wif 8+ years of extensive experience in Database Solutions and 6+ years of BI Solutions using Microsoft Technologies.
• Extensive experience in Data Modeling, Design, Development, Implementation & Administration of Database systems using MSSQL 2008/2012/2014 for both OLTP (Batch Processing, Online Processing) & Data warehousing Systems (SSRS, SSIS, SSAS)
• Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server-based applications.
• Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL
• Excellent noledge of performance tuning in stored procedures and queries, using tools like SQL Profiler, Execution Plans, Database Tuning Advisor, DMV’s wif efficient coding standards.
• Experienced in creating SSIS Packages for integrating data using both heterogeneous and homogenous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Strong noledge and experience in error handling of SSIS packages. using transactions, check points (package restart ability features), break points and error logging procedures.
• Highly experienced in full cycle of DTS/SQL server integration services (SSIS 2008/2012/2014) Packages (Developing, Scheduling, Configuring, Troubleshooting and monitoring) for performing data transfers and ETL Purposes across different servers.
• Interpreting and working wif data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Expert in designing various reports like table format, matrix, dashboards and creating subscriptions using SQL Server Reporting Services (SSRS 2008/2012/2014) and BI tools like Excel, Power Pivot/ Power Query and Power BI.
• Implemented Subscription, schedule refresh, data alert utilizing Power BI Gateway.
• Expert and proficient in highly analytical & detailed reports that include drilldown, drill through, parameterized (Cascading parameters), TopN, Summary, OLAP, cross tab, linked and sub reports and filters, charts in SSRS 2008/2012/2014.
• Highly skilled in developing OLAP cubes using SSAS 2008/2012/2014, calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulae, and user-defined functions.
• Good noledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling, DSV diagrams, Fact and Dimensions Tables using Analysis Services.
• Developed cubes using Partitions, added the Key Performance Indicators (KPI), partition aggregations, Perspectives, slow changing dimensions etc. and created various user roles.

TECHNICAL SKILLS:

BI Tools: SSIS, SSAS, SSRS, QlikView, SSDT (BIDS), Business Objects, Power BI, Power Pivot, Power Query, Visual Studio, Crystal Reports 9.0, Teradata, Performance Point Server, ProClarity, SQL*Plus, SQL*Loader, Erwin Data Modeler, JasperSoft Studio.

Databases: SQL Server 2008/2012/2014, MySQL, Oracle 10g, 11g.

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional

Application package: MS Office Suite, Visio, Power BI

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, C#.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Tools: SQL Server Enterprise Manager, SQL Server Management Studio, Team Foundation Server (TFS)

Protocol: FTP, TCP/IP, Named Pipes

PROFESSIONAL EXPERIENCE

Confidential

SQL/SSIS/SSRS/Power BI Developer

Responsibilities:

• Worked on a legacy project of re-engineering the existing Informatica system to SSIS.
• Identified the processes involved and plan the project timeline accordingly.
• Created a design documentation mentioning the benefits and enhancements of replacing the Informatica wif SSIS.
• Worked wif the fellow developer in gathering the information about the daily jobs, business requirements and logics.
• Intensively worked on writing complex SQL queries, dynamic stored procedures, views, user defined functions and indexes in SQL server 2012 and 2016.
• Responsible for Design, Development and testing of SSIS Packages to load data from various Databases and Files.
• Worked on the existing batch scripts and replaced the same logic wif SSIS.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Worked on writing scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from different source types such as Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Worked on various tasks and transformations like Execute SQL Task, Execute Process Task, Foreach loop, For loop, Conditional split, Merge and Lookup while loading the data into Destination.
• Performed Incremental load wif several Dataflow tasks and Control Flow Tasks using SSIS.
• Organized Error and Event Handling by creating error and process logging tables, DB Mail profiles and using Precedence Constraints, Break Points, Check Points, logging to send the result files to the clients and vendors via Email.
• Created a maintenance script to make the SSIS package re-runnable.
• Added enhancements like data audit check to maintain the data consistency.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis. Monitoring Event Viewer, SQL Error logs for errors.
• Implemented batch processing using Jobs and DTS.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered wif CLR.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports, Cross Tabs, Drill down reports using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Used Power BI Desktop to connect to SSAS cubes (live connection) or directly to database tables (Direct Query Mode) or to flat file sources (Import mode). Design reports based on business requirements. Deploy the reports to Power BI Service Workspaces to create Dashboards for consumption by end users.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points. Developed BI solutions using Power Query.
• Gathered the requirements from the clients and designed Dashboards and Scorecards making sure the response time isn’t effected and published them into the workspace.
• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes Meeting User Needs and Requirements from both technical and strategic views of an organization.
• Successfully tested all task in staging and stored all versions of data using Team Foundation Server (TFS).
• Involved in Mock testing, Unit Testing, Integration testing and Peer review in SSIS, SSAS.

Environment: MS SQL Server 2016/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2012/2015/2017, C#, SQL Server Profiler, Power BI, Power Query, SSMS, Team Foundation Server (TFS), GIT, Business Objects, SharePoint 2012.

Confidential, Cedar Rapids, IA

SQL/SSIS/SSRS/Power BI Developer

Responsibilities:

• Responsible for Design, Development and testing of SSIS Packages to load data from various Databases and Files.
• Data migration (import & export - BCP) from Text to SQL Server.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources (SQL Server, Oracle, DB2 etc.).
• Implemented data partitioning to improve the performance of large table reduces contention and increases availability of data.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Performed Incremental load wif several Dataflow tasks and Control Flow Tasks using SSIS.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, logging to send the result files to the clients and vendors.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Managing SQL servers by performing DBA tasks like Database Backup/Restore and by creating maintenance plans like Daily backup, check DB and weekly rebuild and scheduling jobs on daily/weekly basis. Monitoring Event Viewer, SQL Error logs for errors.
• Implemented batch processing using Jobs and DTS.
• Designed the user interface screens and implemented application logic under the Microsoft .NET framework using C# to use .NET features powered wif CLR.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS and Created calculate member in OLAP cube using MDX in SSAS.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SSAS and DAX was used to create calculated measures and calculated fields.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Developed various dashboards using Power BI to facilitate informed decision making.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS, SSAS.

Environment: MS SQL Server 2014/2012, SSIS/SSAS/SSRS, T-SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Oracle 10g, Power BI, Power Query, SSMS, Team Foundation Server (TFS), SQL Server Data tools, Business Objects, SharePoint 2012.

Confidential, MN

SQL /BI Developer

Responsibilities:

• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers
• Used SSDT to design SSIS packages to transfer data between servers, load data (Excel layouts) into database, and archived data file from different DBMS. Scheduled the job to do dis task periodically.
• Created SSIS script tasks, Lookup transformations and Data flow tasks using C# and VB scripts and other transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created SSIS packages to transfer XML file data into SQL server database.
• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping.
• Using Power BI as a front-end BI tool and Microsoft SQL Server 2012 as a back-end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views. Also modified and created Joins to Improve the Database execution speed.
• Designed and Developed matrix, tabular and parametric, Drill down and Drill Through reports wif Drop down menu option using SSRS and scheduled to generate all daily, weekly, monthly and quarterly Reports including the current status.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View to visualize reports.
• Strong noledge of managed claims management process, Knowledge of Medicaid and Medicare Services. CMS, Health Assessment Systems, Hl7 Standards, HIPAA, PPACA (Patient Protection and Affordable Care Act), Compliance issues, HL7 Message Validation, ICD 9, Electronic Health Records, Electronic Medical Records.
• Involved in Mock testing, Unit Testing and Integration testing in SSIS.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, and Drill through, Sub reports using SSRS
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company wif respect to customers.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports, Cross Tabs, Drill down reports using SSRS.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Used Team Foundation Server (TFS) for source control, and data collection.

Environment: SQL Server 2012, SSIS, SSRS, SSAS, SSDT, Teradata, Visual Studio 2012, Erwin 4.0, QlikView, Power BI, Power Pivot, MS Excel 2010, C#, Team Foundation Server (TFS), Windows Server 2010.

Confidential

SQL BI Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used ASP.Net coding and C# to call the Stored Procedures created wif T-SQL
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports wif Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports in BIDS.
• Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: Windows server 2008/2008R2, MS SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), BIDS, QlikView, Oracle, C#, Power Designer, Microsoft Outlook, Team Foundation Server (TFS).

Confidential

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Wrote Transact SQL utilities to generate table insert and update statements.
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment: SQL Server 2008/2005, T-SQL, .Net, Microsoft Framework 2.0, Erwin, MS Visio.