SUMMARY

• 6 years of experience in SSIS,SSAS,SSRS Reports Development Maintenance & Support of MS SQL Server 2008R2, 2012, 2014,2016 in Production,UAT,QA, Development and Test environments.
• Experience in Database Design and Development, ETL Development, Data warehouse Implementation, Report Development using SSIS, SSRS and TSQL.
• Experience in Creating Database objects - tables, views, functions and developing procedures for implementing application functionality at the database side.
• Strong analytical skills for the understanding and implementation of business logic by designing control flow tasks, dataflow tasks, work flow tasks for Data Conversions and applying Extract, Transform, and Load strategies using SQL Server Integration Services
• Good knowledge in transformation of data between databases using Bulk Insert Tasks, Data Pump Tasks and experience in design, data conversion, data mapping and data load.
• Created and scheduled jobs to run on a daily and weekly basis including maintenance of the jobs.
• Experience in Managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and Visual Studio.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Designed and built SQL dash board for reporting to allow ad hoc reports for management and Intelligence.
• Experience in troubleshooting TSQL queries.
• Experience in creating packages to extract data from MS Excel, MS ACCESS and FLAT FILES and load it to SQL SERVER using DTS/SSIS and implemented Incremental load in SSIS packages.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Expert in transforming complex business logic into Database design and implemented by creating Stored Procedures, Views, and T-SQL Scripting.
• Experienced in creating SSIS packages with complicated transformations and Data migration.
• Active participation in SDLC methodologies specifically Agile Scrum methodology.
• Familiar with Tableau Data Visualization in Creating Work books, Datasets, Data Sources.
• Designed and Maintained Cubes using SQL Server Analysis Services (SSAS).
• Working Knowledge on Power BI Reports and Dashboards.
• Worked on Power BI Reports .
• Deployed Web Based applications into Azure Server by setting up Continuous Integration (CI)/Continuous Deployment (CD) from Team Foundation Server (TFS) .
• Worked on Azure Cloud Management of Web applications
• Migrated SSIS packages from SQL Server 2008 to SSIS 2012.
• Microsoft certified - Querying Microsoft SQL Server 2012/2014.(70-461)
• Microsoft Certified- Administering Microsoft SQL Server 2012/2014 Databases. (70-462)
• Microsoft Certified - Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 - (70-463)

TECHNICAL SKILLS

Operating Systems: Windows SERVER 2008 R2 and 2012

Databases: MS SQL Server 2008R2, 2012 and 2014,2016,Oracle 11g

SQL Server Tools: SSMS, Visual Studio MSBI(SSIS, SSRS,SSAS) 2010,2017,T-SQL,PL/SQL

Reporting Tools: SQL Server Reporting Services,Tableau Desktop,Power BI,Share Point Dashboard Designer

Version Control tools: Microsoft TFS, GIT, SVN

. NET TECHNOLOGIES: C,C#.NET,ASP.NET,MVC,HTML,CSS

Webservers: Internet Information Server (IIS)

PROFESSIONAL EXPERIENCE

Confidential

Apps System Engineer

Responsibilities:

• Gathering requirements from the client, scheduling meetings for detailed analysis
• Created ad-hoc reports using SQL server Reporting Services (SSRS) as per the business need.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions.
• Scheduled and maintained routine jobs, tasks, and alerts
• Built cubes for EPM application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS 2014.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Worked on Team foundation Server source control (TFS) to manage code.
• Generated Reports against Tabular models.
• Integrated the SSRS reports with share point reporting server using Performance Point .
• Worked on Tableau desktop for some of the reports replicating the SSRS reports Worked on all the major SQL-skills like Aggregates, Views, Database objects, stored procedures.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2017.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.

Environment: SQL Server 2016 management studio, Visual studio 2017, Oracle Client 11g, MS Excel, Business Intelligent technologies like SQL, SSIS, SSRS, SSAS, Tableau 8.2, TFS, Share Point Performance point .

Confidential

Business Intelligence Developer

Responsibilities:

• Creating Data Sources,Large Volume Data sets for the Reports.
• Understanding the business related to Auto Insurance, Consumer Warranty, Reinsurance, F&I Administartion.
• Worked on Reinsurance Report Module
• Worked on Dividend Module
• Generated multi parameterized reports in MS SSRS 2010 allowing users the ability to make selections before executing reports, thus making them user friendly.
• Developing Complex Stored Procedures, User Defined Functions, Temporarary Tables, Variables,Queries for the application
• Debugging the Stored Procedures,functions to handle errors
• Developed Various Drill Down, Drill Through Using SSRS as well as managed the subscription of the reports.
• Developed various Sub Reports,Summary Reports,Details Reports,Charts and Matrix Reports
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2014 and in adding calculations using Multidimensional Expression MDX & DAX.
• Involved in Enhancement of Existing Reports as per the customer needs
• Involved in Query Optimization and Performance of the reports
• Created Dynamic Reports to meet the needs of Different TPA’s, Dealers.
• Provided Various levels of User Security for the Reports
• Migrated Reports from Visual Studio 2010 to Visual Studio 2017.
• Responsible for Deploying the Reports to Various Environments(QA,UAT,Production)
• Performed Unit Testing, Functional, Regression and UAT Testing.
• Involved in creating dashboards, reports and then published on to the Tableau server.
• Involved in Migration of SSRS reports to Tableau for Specific Clients
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.
• Extensively created visualization dashboards for the Claims,Contracts.
• Familiar with Tableau Reports
• Familiarity and Experience in Power BI Reports and dashboards .
• Worked Closely with manager on Reinsurance Functional design document and configuartaion .

Environment: SQL Server 2012,2014,2016, SSDT,SSRS,SSAS,Visual Studio 2010,2012,2017,SVN,JIRA, Tableau Desktop 8.1/8.2, Tableau server 8.1/8.2, GIT,Microsoft Excel 2016, Microsoft office 2016,Power BI desktop

Confidential - Chicago,IL

MS SQL Developer /BI Developer

Responsibilities:

• Involved in complete life cycle of SDLC and also responsible for designing of logical as well as physical database.
• Maintained data integrity by performing validation checks such as invalid SSN, email id, phone numbers and address.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity with T - SQL.
• Tested the data with complex queries, joins, sub-queries in temp tables.
• Developed SSIS packages to migrate data from different data sources to data warehouse.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting)
• Rendered reports in different formats like PDF, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured the report viewing security for various users at various levels using Report Manager.
• Documented all database objects, procedures, views, functions & packages for future references.
• Performed all QA testing and match results for different environments.

Environment: MS SQL Server 2012/2008R2, SSAS, SSRS, SSIS, T-SQL, Visual studio 2008

Confidentia

Business Intelligence Developer

Responsibilities:

• Worked as a ETL SSIS, SSRS Developer.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQL Server, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Prepare Unit Test Plan and Integrated test Plan with interface modules.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Data quality done by using the Data cleansing by using ETL development
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Using SSRS for development of reports for Business users from different sources like tables, stored procedures and development of various types of reports.
• Used Team Foundation Server as Source Control to store Packages, Reports and SQL Scripts and share it among team members.
• Designing Spotfire dashboards / reports with complex multiples data sources (SQL, Excel, Flat files) relational design and optimizing applications.
• Deploying and troubleshooting the SSIS Packages.

Environment: MS SQL Server 2008, 2008 R2, 2012, 2014.,SSIS,SSRS,SPOTFIRE,TFS,MICROSOFT EXCEL,MS OFFICE

Confidential

BI Intern

Responsibilities:

• Worked as a SQL, SSIS, SSRS Developer.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Monitoring all production servers' jobs, ETL processes, Data flows regularly.
• Working on existing application enhancements and adding new functionalities.
• Analyzing and providing fixes for all issues arises during business hours and have dataflow continue.
• Analyzing and resolving all issues exists from long time.
• Designing new SSIS packages on demand to provide report collected from various sources
• Designing and providing critical adhoc on demand reports on request.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed, monitored and deployed SSIS packages.

Environment: MS SQL Server 2008 R2 and 2012,MS Excel,Data Analysis.