SUMMARY

• 6 years of experience in IT with Database applications and Business Intelligence Design & development, and Data Analysis in Production, Development, Testing and Staging Environments.
• Expertise in MS SQL Server 2016/2014, MSBI products like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis services (SSAS).
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS).
• Experience in designing, developing, deployingand scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP and Emails Alerts.
• Experience in providing Logging, Error handling by using Event Handler.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Skilled in developing SSAS Cubes, Dimensions, Facts and data source views, SSAS - Data Mining Models and Deploying, ProcessingSSAS objects, and creatingnamed calculations and named queries.
• Good experience with SSRS through deploying reports, creating report schedules and subscriptions, managing and securing reports.
• Design, develop and execute tests that confirm the success of the data conversion process
• Research, analyze and recommend data conversion strategies as required, aligned with CGI’s Architecture guidelines.
• Reconcile converted data to ensure conversion accuracy
• Experience of ETL tools, data conversion and migration of large scale data between systems
• Developed Power BI reports from multiple data Sources.
• Skilled in SQL Server Reporting Services (SSRS 2014/2012) in generating complex reports in cascaded reports, parameterizedreports, and Ad-Hoc reports.
• Utilized Power BI (Power View) to createvarious analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DMLTriggers, Views, User defined data types and functions (UDF’s), Cursors and Indexes using T-SQL.
• Expertise in SQL Server and T-SQL (DDL and DML) in constructing Tables, Indexes, Stored procedures, Views, Normalization techniques on database Tables.
• Expertise in creating/modifying Tables, Views, Stored Procedures, User Defined Functions (UDFs), Common Table Expressions (CTEs), Joins, Indexes, Triggers and Cursors scripting in T-SQL.
• Expertise in writing Sub-Queries and Joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Expertise in creating, scheduling, monitoring, maintaining old and new SQL jobs, using SQL Server Job Agent.
• Expertise in defining the business process flow and gathering business requirements.
• Experience working in Agile and Waterfall methodologies in SDLC
• Hands on Experience in installing, configuring, managing,monitoring and troubleshooting SQL Server 2016/2014.
• Good team player and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MS SQL server 2016/2014/2012 , My SQL

Programming Languages: SQL, PL/SQL

BI Tools: MSBI

ETL Tools: BIDS/SSDT, SSIS, SSAS, SSRS.

OLAP/Reporting Tools: MS SQL Server Reporting Services 2014/2012/2008 R2, SSRS, MS Excel, Tableau, Power BI.

SQL Server Tools: SSMS, Query Analyzer, SQL server profiler, SQL Server Agent.

Data Modeling Tools: Erwin tool, Visual Studio 2010, Microsoft Visio, Business Intelligence Development Studio (BIDS).

Other Tools: MS Office, MS Excel, MS Project, MS PowerPoint and MS Visio

Operating Systems: Windows 10/8/7/XP/Vista, MS-DOS, UNIX, LINUX.

Web Development: HTML, XML, Microsoft.NET framework, Visual Studio.

PROFESSIONAL EXPERIENCE

Confidential - RI

ETL MODELER

Responsibilities:

• Responsible for database development, data flow, integration and data modeling.
• Responsible for UI development on Axeda platform using HTML, java script, Groovy and jquery
• Using Erwin, develop conceptual models and create various logical and physical models such as relational and dimensional data models.
• Design and develop informatica mappings and sessions based on business user requirements and business rules to load data from source to targets.
• Extensively worked with repository manager, designer, workflow manager and workflow monitor
• Responsible for the data integration into Salesforce.com using Informatica power center and informatica cloud
• Responsible for the data integration Axeda cloud to Ecolab systems using informatica power center
• Configured and used FTP by the Informatica server to access source files
• Responsible to work on Agile / Scrum development methodologies
• Worked with advanced systems like web services and messaging queues active MQ
• Analyze business data requirements to produce relevant ETL architecture deliverable source analysis, source to target maps, ETL flows in data warehouse environment
• Creating various forms of documentation like data design documents/conceptual design documents/DDL for various projects.
• Effectively explains data related concepts at both IT and business user levels.

Confidential - Illinois

ETL MODELER

Responsibilities:

• Met with business users, gathered business requirements and prepared the documentation for requirement analysis.
• Provided training to the business users on how to use new data warehouse, browsing cubes from Excel and assisted them in rewriting their existing queries to point to the new warehouse.
• Created centralized data warehouse (ODS) and developed de-normalized structures based on the requirements and to improve the query performance for end users.
• Created ETL design specifications, performed unit testing, data validations, integration testing and UAT and deployed SSIS packages to development and test environments.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Created and Designed a Multi-Dimensional Analysis (Configured OLAP Cubes, Dimensions, Measures, MDX Queries, Data mining, Data Source and Data Source Views and Star schema) using SQLServer Analysis Services (SSAS).
• Worked with SSAS tabular model (BISM) and created dashboards and reports using power view, power pivot and SSRS.
• Deploy, Configure, Maintain Compute on Azure Cloud.
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Used data quality services (DQS) to cleanse the data, remove duplicates and improve the quality. Created domains in DQS and exported the activity results into SQL tables.
• Sets expectations around data conversion with client team (especially around expectations the CDAT Delivery team has of the Client Delivery team and vice versa)
• Communicate effectively with management during data conversion process
• Strong professional who has experience in leading the data conversion to support an Oracle Federal Financial implementation.
• Did debugging using break points and data viewers and performance tuning of ETL data flows.
• Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction-based data).
• Created and configured SSIS packageconfigurations using SQL server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS packages.
• Configured OLAP Cubes (Star Schema) using SQL Server 2014 Analysis Servicesand Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Created calculated columns, KPIs and custom hierarchies to accommodate business requirements and partitioned the cubes to improve the performance and to decrease the processing time.
• Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.
• Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.
• Designed SSAS tabular models and created dashboards and reports using power view and deployed them in Share point server.
• Developed various types of reports drill down, drill through, matrix and sub reports using SSRS.
• Created multiple dashboards with calculations and KPIs using Tableau 9.3/10 and deployed them in tableau server
• Used team foundation server for version controlling of all BI projects.

Environment: SQL Server 2016, SSMS, SSIS, SSAS Tabular, SSRS, Power View, Power Pivot, MDX, Report Builder 4.0, Team Foundation Server, MS Visio, Outlook, T-SQL, Windows Server 2012, Windows 8.

Confidential - MA

ETL DEVELOPER

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Installed SQL Server 2014 and Management tools using SQL Server Setup Program and upgraded existing databases from SQL Server 2012.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to load the shipping and customer data.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
• Created custom logging and package configurations to change connection strings and variables dynamically. Used all types of containers in SSIS.
• Created package deployment utility and deployed packages into various environments. Involved in unit testing, SIT, UAT and data validations.
• Designed, processed and partitioned cubes using SSAS.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Writing variousT-SQLqueries,Stored Proceduresand used them to build packages.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Microsoft SQL Server 2008 reporting services.
• Created and maintained SSRS reports for External Reporting and Internal Activity Based Costing (ABC) for shipments tracking.
• Outstanding knowledge in creating drill down reports, Graphical reports, ad-hoc reports and drill through reports using the ROLAP/MOLAP as sources.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Worked in agile methodology, participated in daily scrum meetings.

Environment: Agile,SQL Server 2014, SSIS, SSAS, SSRS, Share point, Oracle, MDX, MS Office 2007, ER Win, T-SQL, Windows Server 2008.

Confidential - TX

SQL Developer (MSBI)

Responsibilities:

• Actively participated in the meetings between Business Users and Technical team to gather and discuss the business requirements and convert them into technical/functional requirements.
• Initiated to implement technological solutions in a cost-effective way by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators and partners.
• Designed SSIS Packages to perform the extract, transfer, and load (ETL) operations with existing data into SQL Server through OLTP database from different data sources.
• Worked with SSIS Data flow task, Transformations, For-loop containers and Fuzzy Lookups, Data conversion and configured data in slowly changing dimension.
• Worked with team to Develop and Extend the OLAP Cubes, Dimensions and data source view.
• Designed and implement Data Mart, Facts, Dimensions and OLAP Cubes using dimensional modeling standards in SQL Server 2012 that maintained data.
• Worked in the complete Data Warehouse development life cycle and actively supported business users for change requests during the project development.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Worked with the team in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created dashboards and custom reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed several drill down and drill through reports using SSRS as needed by clients.
• Used Joins, sub-queries, Stored Procedures, Indexes, and Views for involving multiple tables from different databases to integrate the data as business requirements
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2014, SSIS, SSAS, SSRS, visual studio, Import/Export tools, SQL Server Agent, MS Access, T-SQL, ERWIN and Windows10.

Confidential - KS

SQL Developer

Responsibilities:

• Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces.
• Identified various source systems for data feeds.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed and developed jobs for loading data to star schema.
• Extracted Data using SSIS from DB2, and flat files, Excel transformations.
• Populate the data warehouse. Worked on SSIS to remove duplicate records with data standardization.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Work directly with customers, functional Analysts and integration Analysts to establish conversion approach, complete migration of configuration and to complete the data conversion / load of customer data into Workday.
• Created various Jobs, Alerts and Events, Created Backups for databases and automated the process.
• Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI’s for user perspectives.
• Participates, approves and oversees the data conversion of company data during the project for stakeholders.
• Work cooperatively with the Deployment Specialist to complete data conversion as outlined within the workflow for the customer.
• Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using T-SQL for different applications.
• Managed index and optimized queries using execution plan.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Involved in the Analysis of the Report Data, Developed and Deployed Reportson to the Reporting Server. Wrote and integrated stored procedures to generate the reports.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.

Environment: SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSAS, Power Pivot, MS Access, SharePoint server, Windows 8/7.