SUMMARY

• 8+ years of experience in complete MSBI Stack including data analysis, Schema design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
• More than 2 years of experience in Microsoft Power BI, Power Query, DAX and Power Pivot
• Experienced in full life cycle ETL development using SSIS.
• Extensive experience in creating many complex SSIS packages using SQL Server Integration Services … R2.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server … R2.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data.
• Experienced in Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Experience in Extraction and Migration of Data from heterogeneous data sources like flat files, CSV, Excel, MS Access, Oracle, XML & MS SQL Server using SSIS.
• Experienced in Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel data into database.
• Experience in creating Data Driven, Drill Through, Drill Down, Tabular, Matrix reports & created charts, graphs using SQL Server Reporting Services … R2.
• Tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
• Extensive experience in publishing reports and dashboards using Power BI.
• Created reports in Power BI by importing data, shaped and transformed data for business intelligence (BI), Visualize data, author reports, scheduled automated refresh of reports and created and share dashboards based on reports in Power BI desktop.
• Extensive experience in working with very large databases and Performance tuning.
• Experience in Designing reports using Report Designer, Report Builder3.1, Report Manager, creating parameterized reports & managing subscriptions.
• Worked on Report Manager to subscribe reports, Assign roles, user access with respect to security.
• Experienced in working in Agile and Scrum Methodology environment.
• In - depth understanding of all stages of software development life cycle (SDLC).
• Good knowledge and experience in Data Warehouse design (Kimball Group) of Dimensional Modeling, ETL Design and Dimensional and Facts Maintenance.
• Fine-tuned and optimized queries by altering database design, analyzing different query options and indexing strategies.
• Experienced in documenting the requirements and good understanding of the change control process.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 8i/9i/10g, MS-Access 97- 2007

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services(SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, c#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin, Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for Business Operations Reporting for the collection and analysis of operational metrics and key performance indicators (KPI's) to all of Citi Technical Infrastructure management. Expanding their Central Reporting Utility to provide robust self-service capabilities.
• Responsible for the creation and enhancement of web applications to support the reporting needs of the Citi Business Management, Analytics team and their customers.
• Extracting business data from different OLTP systems and loads into data warehouse using SQL server Integration Services (SSIS).
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Worked on providing row level securities using power bi to restrict data access for various users.
• Creates maintenance plans, stored procedures and functions using Transact-SQL to increase performance and ease of access for data manipulations.
• Creates and implements Microsoft Office Suite custom applications to interface attorneys with data and automates applications to assist with creations of document production sets and privilege logs.
• Utilizes SQL- DML, DDL, and DCL classes to setup, create, maintain, and manage SQL databases backend functions daily.
• Used SQL Databases, Data Lakes, SSIS, and SSAS tabular models to capture features used to train risk attribute models used to score and identify high risk deals.
• Used TFS (Team Foundation Server) and Visual studio Team services (VSTS) to share all the work, code, to sort out the exceptions raised during work.
• Responsible for creating documentation to assist my team to effectively transfer duties of different projects to one another.
• Identify and implement new procedures to simplify and improve process.

Environment: MS SQL Server 2016, 2015 Visual Studio 2017, 2015, SQL Server Integration Services (SSIS), SSRS, Data Warehouse, Widows server 2012, Linux server.

Confidential

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Designed and implemented data access stored procedures and triggers for automating tasks. Perform standard QA-Testing of SSIS Packages.
• Created SQL server Reports using SSRS 2005 for the manager and the brokers involved and formatted the report layout for the requirement of the end users.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server, 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.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Generated reports for end user requirements using SSRS. Deployed developed reports on to the server for the end users.
• Expert in cleansing data for data consistency whether the data source is a single system or multiple disparate sources. Expert in Merge Join transformation, which can take two different inputs and merge them together by comparing a set of key columns, which performs different types of joins.
• Experience in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Data migration (import & export -BCP) from Text to SQL server.
• Designed SQL SSIS Packages in Business Intelligence Development Studio (BIDS), to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 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; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Visual Studio.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Created & Managed Database Objects such as Stored Procedures, Views, Tables & Function to support application team & Ad Hoc Data Request.
• Updated existing Stored Procedures to accommodate new business rules and processes
• Worked on Data Mapping and Documentation.
• Built reports in SSRS for errors generated by SSIS Packages; generated Reports using Data Source Views in Report Builder; created Drill down Drill through, linked and sub reports using SSRS.
• Installed & Configured SQL Server Reporting Service (SSRS).

Environment: MS SQL Server 2016, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL, Tableau Desktop, Power BI

Confidential - Washington, DC

SQL/BI Developer

Responsibilities:

• Assisted in Business Analysts to gather technical requirements.
• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse. Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Work with Service Management teams to establish and monitor service level agreements, communication protocols with data suppliers and data quality assurance policies.
• Provide data quality advisory services to clients and to internal stakeholders. Recommend maintenance enhancements to data acquisition processes to improve accuracy of data warehouse data.
• Perform support functions and develop fixes accordingly for our Association Management System, Manage and actively participate in system and user acceptance testing.
• Provide technology options and recommendations to solve for business challenges, Strong knowledge of database and system performance monitoring. Ability to share and communicate ideas both written and verbally to staff at various levels within the organization in a clear and concise manner that is relevant to each level.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Have good business analytical and technical knowledge in Healthcare Membership, Benefits and Provider Modules in FACETS.
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task FailedEvent Types.

Environment: MS SQL Server 2014/2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Office.