SUMMARY:

• 8 years of experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) and Data Transformation Services (DTS) and Talend.
• Application knowledge in software development life cycle (SDLC), Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Extensive Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development, and Reporting.
• In - depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables
• Good knowledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Experienced in Migrating data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Developed financial models, BI reports, defined built key metrics, KPIs, scorecards chart rich reports using complex excel functions, advanced Macro, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX and Tableau Visualization Tool .
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Responsible for loading data files from various externalsources like ORACLE, MySQL into staging area in MySQL and vertica databases. Utilized python, SQL, unix shellto load data.
• Migrate existing data into the Power BI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, SQL Server Integration Services (SSIS), Analysis Services (MDS), and Reporting Services (SSRS).
• I analyzed loaded data using SSAS, built models/cubes using data sources for Data warehouse and queried cube using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS)
• Created Dimension types such as Standard dimension, Parent-Child dimension and Role Play dimension in SSAS
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data . Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Expertise in scripting T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS),Talend

Reporting Tools: SSRS, Crystal Reports XI/X/9/8, Excel, PowerBI, Tableau

Database: MS SQL Server, Oracle 10g/9i/8i, MYSQL, MS-ACCES, MDS

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, Java, EE, Shell Scripting,Python.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JSON, JavaScript, PHP, jQuery.

PROFESSIONAL EXPERIENCE:

SQL/SSIS/SSRS/SSAS/Power BI Developer

Confidential, MD

Responsibilities:

• Experienced in extracting data from various data sources like: Oracle and SQL server, raw file, flat file, Excel, and OLE DB sources from Client servers.
• Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.
• Expertise in troubleshooting ETL packages by implementing SSIS functionalities, like: breakpoints, checkpoints and event handler.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Tune ETL procedures and STAR schemas to optimize load and query Performance.
• Prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
• Experienced in using SSIS catalog, File System SQL Server deployment process to deploy ETL packages.
• Utilized configuration tables to update multiple SSIS packages simultaneously.
• Implemented Custom Logging, Auditing and custom Email notifications using SSIS.
• Analyzing the source data to know the quality of data by using Talend Data Quality.
• Used SQL queries and other data analysis methods, as well as TalendEnterprise Data QualityPlatform for profiling and comparison of data, which will be used to make decisions regarding how tomeasure business rules and quality of the data.
• Build complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of star schema or snow-flex schema.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• The created cubes were analysed using MDX and DAX . I also analysed and modified data using Power Pivot, created pivot tables and charts for presentation and decision making purposes.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.
• Responsible for scheduling the subscription reports with the subscription Report Wizard .
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Responsible for developing ETL programs to applytransformations to the staged data and load into targetschema in Vertica. Utilized python, SQL, analyticalfunctions, unix shell to load data.
• Involved in Installation, Configuration and Deployment of Reports using SSRS.
• Scheduled the reports to run on daily, weekly basis in the report manager.

Environment: MS Visio 2008, SQL Server 2012, Microsoft Visual Studio 2010, Windows 7, MS Office, Windows Server,Dax, SQL Server Integrated Services SSIS, SQL Server Analysis Services SSAS, SQL Server Reporting Services SSRS, SharePoint, Oracle 8, Tableau, Power pivot, Power view, Power BI, Talend,Python.

SQK BI/SSIS/SSRS/SSAS ETL-Developer

Confidential, NH

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Converted various data files (CSV, XML, COBOL and Legacy Flat Files) based on business logic using Script Task and Script Component.
• Generated 7M Record files using SSISScript Task and Script component Format the files based on client requested format using.
• Created triggers for a Talend job to run automatically on server.
• Worked on Exporting and Importing of Talend jobs.
• Worked on the design, development and testing of Talend mappings.
• Setup the client packages for Accounts, Transactions and Notes based on Templates.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• 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.
• Creating, Modifying SSASMeasures, DimensionsAttribute relationships and Hierarchies.
• Designed SSASCubes, Named Calculations for Dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Used Power BI for developing reports, data marts, KPI’s and charts for the organization and departments.
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Built cubes using Kimball methodology and queried them with MDX and DAX.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.

Environment: SQL Server 2008, Visual Studio 2005,Microsoft Visual Basic, Microsoft Visio, Windows 2003 R2,Dax,Power pivot, Power view, Power BI,Talend

SQL/SSIS/SSRS/SSAS Developer

Confidential, Hartfort, CT

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration of DTS packages to SSIS packages
• Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.
• Installed on premise data gateway and scheduled daily data refresh in Power BI .
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from business.
• Publishing Power BI Reports from Power BI Desktop to Power BI Service.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-node Cluster with Mulch-instances.
• Configured and Monitored Database Mirroring for Application Development environment
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Built models using data sources for Data warehouse and queried cube using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) and using Power Pivot for analysis included functions in MDX queries and metadata
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Performed Database Refresh tasks from production to Development and Staging Servers
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Handled Scheduled backups and restore operations with Lite speed 5.0 and monitored the Tasks, Maintenance plans.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server,Dax, Power BI, MS TFS, MS-Access.

MSBI Engineer

Confidential, Salem, OR

Responsibilities:

• Created T-SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designingand implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.
• Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2005.
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Developed various kinds of Tabular, Matrix, Drill-down, Charts, and web receiving reports using SSRS.
• Defined calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Created the Cubes and Dimensions.
• Upgraded Analysis Service 2000 to SSAS 2005.
• Identified and Defined Key Performance Indicators in SSAS 2005.
• Defined relationships between Measure groups and Dimensions.
• Conceptualized and Designed Logical and Physical Data Models using ERWIN.
• Analyzed the project database requirements from the user.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed the complex business logic and calculations into coding.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Worked with Exception handling with @@error and with Try/catch.
• Defined granularity with in a measure group and drill through actions.
• Maintained Security Role and Database Users.

Environment: MS SQL Server 2005 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, MS-Access, Oracle 9i.

SQL Developer

Confidential

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2000 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation ofDTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2008 Enterprise Edition, MS Analysis Services 2005, Analysis Services 2000, MS Access, SSIS, Erwin 4.1, Windows XP Professional, MS-Access, Oracle 9i.