PROFESSIONAL SUMMARY:

• Over 6+ years of experience in the field of Data Warehousing and Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services.
• Expertise in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008.
• Worked Extensively on ETL process using SSIS packages.
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Aware of SDLC procedures, Change control methodologies, problem management and escalation procedures.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back - up/recovery, running Database Consistency Checks using DBCC.
• Experience in Dimensional Modeling, designing of STAR, SNOWFLAKE Schemas.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation.
• Develop ETL Packages using Talend and able to write customized scripts to perform complex tasks
• Good knowledge of System Development Life Cycle (SDLC).
• Good in implementing SQL Server Security and Process Control.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, DAX, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, Python

Databases: MS SQL Server,2014/2012,2008R2,2008 Oracle 8i/9i,10g,DB2

DWH /BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQLServerAnalysisServices(SSAS),BusinessIntelligenceDevelopmentStudio(BIDS),PowerBI,InformaticaPowerCenter 9.6/9.6.1/10.0 (Repository Manager, Designer, Workflow Manager, Work Flow Monitor Visual Studio, Crystal Reports, Talend, Tableau Reporting.

Database DesignTools andDataModeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Tableau, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL BI/Power BI Developer

Responsibilities:

• Wrote stored procedures and User Defined Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Developed multiple tabular models in SQL Server Data Tools SSDT for analytic reporting as well as aggregated data reports.
• Responsible for development of complex reports by using SSRS. Developed various Cross Tab Reports, Drill down, Sub Reports, and Parameter Reports
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports Including current project status.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created multiple automated reports and dashboards sourced from data warehouse using SSRS.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Scheduled jobs for creating snapshot of Power BI Reports and Dashboards and troubleshooting on datasets for Power BI sites
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Created drill down, drill through, sub and linked reports using MS SSRS as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Provided MS SSRS training to clients for them to develop their own ad-hoc reports.
• Resolved issues related to query optimization, database optimization and index tuning.

Environment: Microsoft-VisualC#-2015,Microsoft-Visual-Basic-2015,MSSQL 2008/2012/201/2016, T-SQL,PowerBI,Visual-Studio2012,2015, SharePoint2007/2010,SSAS,SSRS,SSIS,Erwin,AutoSysSchedulerGitHub.

Confidential, Chattanooga, TN

SQL BI/Power BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
• Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business
• Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’s business requirements.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Designed and developed Power BI dashboards, Reports and published it on Power BI sites
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Modify the existing Claims Summary Report by removing two calculated measure from Claims Tabular Model.
• Create a new Audit Tracking column in claims Report by adding one new calculated measure from Claims Tabular Model.
• Work on Tabular Modeling Development and Multidimensional Modelling Development using SSDT. Create additional Timestamp for report.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed complex web forms using ASP.Net server-side scripting with C#, .NET Framework 3.5
• Utilized VB Scripting, C#, WCF, Web Forms for developing the codes
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.

Environment: Microsoft-VisualC#-2015,Microsoft-Visual-Basic-2015,MSSQL 2008/2012/201/2016, T-SQL,PowerBI,Visual-Studio2012,2015,SharePoint2007/2010,SSAS,SSRS,SSIS,Erwin,AutoSysSchedulerGitHub.

Confidential, St louis, MO

ETL- SQL Developer (SSIS/SSRS)

Responsibilities:•

• Gathered and translated business requirements into detailed, production - level technical specifications detailing new features and enhancements to existing business functionality.
• Created logical/physical models and conceptual models using ERwin and VISIO for Reporting.
• Participated in JAD sessions to resolve critical issues.
• Worked on projects in Agile (Scrum) and Waterfall development methodologies for Informatica.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte s and redesigning schemas.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created multiple automated reports and dashboards sourced from data warehouse using SSRS.
• Experience in creating dashboards using Power BI.
• Experience developing, Testing, deploying Power BI reports.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS SQL Server 2008 to MS SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Worked intensively in query execution plans, SQL profilers and did query optimization.
• Integrated data from multiple sources and stored them in Operational Data Stores (ODS) to pass it further down to Warehouse for reporting purposes.
• Worked on both Normalization and De-normalization approach and implemented them appropriately for Warehouses and Marts.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Used DataStage stages Complex flat file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Funnel, Peek and Row Generator stages in accomplishing the ETL coding.
• Created various weekly and monthly reports showing detailed information in SSRS.

Environment: SQL Server 2012/2014/2016, Power BI, Informatica Power Center, MS SQL Server 2008/2012, MicroStrategy, TSQL, Visual Studio, SharePoint 2010, DataStage Version Control, Team Foundation Server (TFS), SSIS, SSRS, Erwin.

Confidential, Wayne, NJ

SQL Developer (SSIS/SSRS)

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Analyzed and designed software and database solutions.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed a High - level dashboard using SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Built SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Used VS Team Foundation Server (TFS) for version control and actively involved in developing Project Plans.

Environment: SQL Server 2008/2012, Reporting Services (SSRS), PL/SQL, Tableau, Informatica Workflow Manager, SQL Plus, Integration Services (SSIS), Analysis Services (SSAS), Team Foundation Server (TFS, T-SQL, MDX, Windows, XML, MS Excel.

Confidential

SQL MSBI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• C reated efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Worked on Filtered Views, views and Base table integration between different Source systems.

Environment: Windows2008 Advanced Server, T-SQL ODBC, MS SQL Server 2005/2008/2012, TSQL, Visual Studio 2008, Oracle, SSRS, SSIS, Erwin.

Confidential

SQL Developer

Responsibilities:

• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Performing Replication (snapshot and transactional).
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Environment: MS SQL Server 2005/2008/2012, TSQL, ASP.Net, Visual Studio 2008, SSRS, SSIS.