SUMMARY:

• Over 8 years of IT experience with extensive background in designing, development and maintenance of databases using SQL Server 2008/2012/2014/2016. Experience encompasses various fields like Banking, Financial services and Healthcare. Proficient in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and good knowledge on SQL Server Analysis Services (SSAS), experienced in working with project team through all phases of software development life cycle (SDLC) - Feasibility study, Project Analysis, Requirements, Design, Development, Testing, Documentation, and Warranty Support.
• Expertise in building ETL solutions for data warehousing using SQL server integration services (SSIS).
• Well experienced in design and development of ETL packages for integrating data from various data sources (Excel, Xml, flat file, Web API’s, MS Access) to MS SQL Server using Data Tools like SQL Server Integration services (SSIS).
• Extensively worked on creating ETL packages using various control flow and data flow items.
• Experience in creating Complex packages with Error handling, Notifications, and Package Configurations.
• Experience in creating jobs, Alerts and Scheduling the DTS packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Hands on experience in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert etc.
• Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems, Designing, Scheduling and Maintaining ETL Framework for different Processes.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Used multi-dimensional expressions (MDX) queries for calculated members of OLAP cube, KPIs, partitions, aggregation, and measures in SSAS.
• Holds expertise in creating tables, indexes, views, stored procedures, triggers using T-SQL while considering tactics for optimum performance

TECHNICAL SKILLS:

Database Programming: T-SQL, PL/SQL

Data Visualization Tools: Microsoft Power BI, Tableau

Database Engines: SQL Server 2016, 2014, 2012, 2008R2 Business Intelligent (BI) Tools: Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

Operating System: Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

MSBI Developer (SSIS / SSRS / SSAS)

Responsibilities:

• Investigate and resolve data issues and make recommendations for improvements such as automation to avoid manual tasks.
• Extracted data from Oracle, Flat Files, Transformed and Loaded into target Data Warehouse using SSIS.
• Designed SSIS packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Understand and analyze business data requirements to create an accurate, extensible, flexible logical Data Models using modelling tools.
• Worked on Huge data transfers from & to SQL Server Databases using utilities like SQL Server Integration Services, BULK INSERT etc.
• Involved in Query optimization and tuning stored procedures for better performance.
• Interacted with team leaders and executive sponsors to gather both Functional and Technical requirements
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, sub reports using SQL Server Reporting Services.
• Highly Proficient in writing complex SQL queries for Joins, Views, Stored Procedures, Triggers and User Functions
• Designed and Published Power BI dashboards
• I worked with time intelligence functions like PreviousYear(), Previousday(), openingbalancemonth for the data analysis
• Created different types of Tabular, Matrix, Drill-Down, cascaded parameterized, Chart report and Sub reports in multiple formats using SSRS.
• Used Parameter, Expression, Grouping, Total and Formatting in SSRS reports.
• Worked with DBA to design/implement/maintain the Data Warehouse and Business Intelligence solutions.
• Analyzed data for data quality and improved data architecture.
• Designed new metrics and prepared reports to monitor forecast accurately and analyze trends
• I implemented forecasting, cumulative totals, sales in progress & orders in progress using dax

Environment: MS SQL Server 2012/2014, MS SQL Server Integration Services, MS SQL Server Reporting Services, T-SQL, SQL Profiler, Query Analyzer, Visual Studio, MS Access

Confidential, Jefferson Hills, PA

SQL Server Developer

Responsibilities:

• Analyzed the existing tool and participated in meeting with the business users to gather requirements and design goals for the data warehouse.
• Used various Transformations in SSIS Dataflow, Control Flow using For loop containers and Fuzzy Lookups etc.
• Developed reports in SSRS 2012 and deployed reports to the SharePoint Server.
• Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
• Participated in Agile methodology with business analysts and end clients.
• Created ad-hoc reports, chart reports, tabular and matrix and parameterized reports using Report Builder 2.0.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub reports according to business requirements.
• Worked on daily batch loads like Full and Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SSIS
• Performed Data Modelling in support of application development for operational and reporting database.
• Performed/automated many ETL related tasks including data cleaning, conversion, and transformations to load OLTP data into OLAP.
• Worked on complete SSIS lifecycle in creating SSIS packages, building, deploying, and executing the packages.
• Created SSIS packages using various Transformations such as Conditional Split, Fuzzy Lookups, Multicasting and Aggregations.
• Involved in regression Testing and optimization of the query.
• Wrote complex SQL queries for Joins, Views, Stored procedures, Parameters, Triggers and User Functions.

Environment: MS SQL Server 2012, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS SQL Server Analysis Services, T-SQL, SQL Profiler, Query Analyzer, MS Excel, Visual Studio, MS Access, Oracle Data Modeller

Confidential, Pensacola, FL

MSBI Developer (SSRS, SSIS,)

Responsibilities:

• Used various control flow task elements like Execute SQL Task, XML Task, Bulk Insert task, Profiling Task and Containers while designing SSIS packages.
• Developing daily, monthly, and quarterly reports from the OLAP cube using SSRS
• Modified existing stored procedures and performed index analysis to improve the performance of existing slow performing data parameterized reports
• Designed and developed SSIS packages to load the data from various kinds of sources like Flat Files, XML, Excel Files to SQL Server Database
• Actively participated in reviewing insurance applications and interacting with business users to understand user requirements.
• Analyzed large volumes of transactional data from a variety of sources and formats, prepared data for processing and analysis request.
• Used complicated Data Flow Transformations like Lookup, Conditional Split, Derived Column, Multicast, Merge, Data conversion and Union all.
• Developed parameterized reports for generating Ad-Hoc reports as per client requirements.
• According to business requirements developed Tabular reports, Matrix reports, Chart reports, Parameters, Sub reports, Ad-hoc reports, Drill through and Drill down reports using SSRS.
• Actively involved in gathering and analyzing business requirements, working with technology team to recommend and implement best approaches to deliver business solutions.
• Responsible for designing SSIS packages to validate, extract data from various data sources like Flat Files, Excel spread sheets and OLTP databases into SQL Server.
• Performed maintenance like tuning, and optimizing the SQL queries, Stored procedures and functions.
• Developed and maintained multiple Power BI reports dashboards and content packs.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), T-SQL, Tableau, MS Excel, MS Power Point

Confidential

SQL Server Developer

Responsibilities:

• Wrote complex SQL queries using Joins and Correlated sub queries to retrieve data from the database
• Scheduled and maintained packages using the SQL Server Agent in SSMS
• Created database objects like Tables, Stored Procedure, Functions, Triggers using T-SQL to provide structure to store data to maintain the database efficiently.
• Created and modified various stored procedures using T-SQL
• Created daily tasks including backup and restore by using MS SQL Server 2008R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent etc.
• Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
• Performed data entry functions including transcribing from source documents to a computer database.
• Verified accuracy and completeness of data
• Used SQL Server Profiler for auditing and analyzing the events which occurred during a time and stored it in a script.
• Documented all work so users can understand the flow of process.

Environment: MS SQL Server 2008R2, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Excel, T-SQL, T-SQL, MS PowerPoint