SUMMARY:

• 5 years of professional experience in working with projects driven on SQL Microsoft Business Intelligence tools, IBM Info Sphere Data Stage , Data Warehousing, ETL processes and Power BI.
• Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access.
• Working with T - SQL (DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes , User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Proficient in the SSAS storage and partitions, aggregations, defining hierarchies, calculation of queries and developing reports using MDX and T-SQL.
• Extensive experience in creating Drill-down and Drill-through Reports (SSIS/SSRS), writing Expressions in SSRS and Fine-tuning Reports
• Experience in Configure and maintain Report Manager and Report Server for SSRS , Deployed and Scheduled the Reports in Report Manager .
• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files , and XML using DTS, SSIS .
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016/2014/2012/2008 MS - Access 16.0/15.0/14.0/12.0

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS)

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 12/9 9.3

Data Modeling: Fact and Dimensional Data Modeling, UML, Logical data modeling and Physical data modeling

ETL Tools: SQL Server Integration Services (SSIS), IBM Data Stage 7.5

Operating System: Windows 2010/7/8.1/8/7 , Linux CentOS 7, Windows Server 2008 R2

Designing Tools: Rational Rose, MS Visio

Applications / IDE: Visual Studio 2015/13/12/10 , Adobe Photoshop, Adobe Dream viewer

MSOffice, MS: Project

WORK EXPERIENCE:

Confidential

MS SQL Developer/ MSBI Developer, Atlanta, GA

Environment: MS SQL Server 2014,.Net 3.0, SQL BI Suite (SSIS), XML, MS Excel, MS Access 2014Windows Server 2010, SQL Profiler, DTS, Data Analyzer, SQL Server Data Tools/BI (SSDT), Red Gate SQL Source Control, TFS, Remote Desktop Connection (RDC), Windows Server 2010 R2, Windows 10, SQL Profiler.

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate Interfaces for the Reporting Infrastructure Environment to meet customer business needs, based on business processes and data entities between various systems.
• Supported front-end team in Designing and Developing custom web and console applications as per client requirements and specifications.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, and Graphs.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Developing complex SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database
• Developing SSIS packages that upload multiple flat files using For each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Improving the database performance by creating and using both Clustered and non-Clustered Indexes and by optimizing T-SQL statements.
• Created ETL process using SSIS to transfer data from heterogeneous data sources by extensively using PIVOT to normalize the data also combining data from different sources using UNION ALL.
• Developed Complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developing SSIS packages that upload multiple flat files using For Each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.
• Created and managed Database(s) on SQL AZURE. Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Confidential

MS SQL Server Developer, Towson, MD

Environment: SQL Server 2012/2016, Power BI, Azure PDW, T-SQL, MS Excel, Visual Studio, VB.netC#, MS SSIS, MS Reporting Services (SSRS), SQL Server Report Builder 2016, TFS, Agile, Oracle 11g

Responsibilities:

• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema in SSAS.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Created packages in SSIS with error handling.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in and support and also have experience in incremental data loading.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.

Confidential

SQL Server / SSIS /SSRS Developer

Environment: C#.net, ASP.net, Rational Rose, Crystal Reports, Web Services, ADO.net, SQL Server 2008, DTS, SSIS, SSRS, SQL Server OLAP 2008, Reporting Services 2008, T-SQL, MS Access, Windows 2003 Server.

Responsibilities:

• Involved in gathering of all the requirements for the project. Implemented the SDLC concept.
• Used Rational Rose for UML diagrams and ER diagrams.
• Developed a web application using C#.net and ASP.net.
• Created user controls for login pages and also used validation controls.
• Provided authorization to control user access to application features.
• ADO.net data accessing using stored procedures.
• Created tables and wrote stored procedures using SQL Server 2000.
• Developed web services and consumed them in the project.
• Created Reports and designed graphical representation of analyzed data.
• Designed screen shots for the frontend users and also handled the backend.
• Involved in checking of coding standards and code review for application code.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
• Developed reports in SQL Server Reporting Services.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like for Loop Container, For each Loop Container etc.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Triggers (Instead of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Performed validations in Excel by creating pivot tables.
• Prepared detailed documentation for the business requirements.

Confidential

SQL Developer

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Wrote various Stored Procedures for the purpose of application development
• Tuned SQL statements (e.g: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis