SUMMARY

• Highly professional and well - versed MS SQL BI Developer wif over all 8 years' experience in designing and developing wif strong background in Data warehousing and ETL experience.
• Experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• MS SQL Server Development experience wif expertise in MS SQL Server and over 6+ years of experience in Microsoft Business intelligence stack products like SSIS and SSRS.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and SQL joins.
• Strong experience on developing ER diagrams like logical and physical data models using Erwin tool, Visio and Power Builder.
• Strong Knowledge on Normalization /De-normalization database design methodology.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL processes across different servers.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail and schedule SSIS Packages based on Business or Application needs.
• Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.
• Used 2012, 2014, 2016 version of SSAS to develop tabular models and experience in performing tuning of tabular cubes.
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema and Operational Data Store (ODS).
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Experience in configuring security, organizational content packs, data Gateways, refresh schedules for PowerBI service.
• Expertise in developing, enhancing and tuning of Oracle database objects and advanced PL/SQL programs.
• Experience in working in agile scrum development methodology.
• Excellent interpersonal abilities, communication skills, time management and team skills wif an intention to work hard to attain project deadlines under stressful environments.
• Flexible and versatile to adapt to new- environment and technologies.

TECHNICAL SKILLS:

Technology: Microsoft Business Intelligence Tools (MSBI)

ETL Tools: Azure, SQL Server 2008R2/2012/2014/2016 Integration services, Query Analyzer, SSDT Tool, SQL Server

Profiler Analysis Tools: SQL Server 2008R2/2012/2014/2016 Analysis services

Reporting Tools: SQL Server 2008R2/2012/2014/2016 Reporting services

Power BI Database: MS SQL Server 2008 R2/ 2005/ 2000 / 7.0, TSQL, PL/SQL, Teradata, Oracle 8/8i/9i, IBM Db2 8.1 and MS Access

Languages & OS: T-SQL, HTML, Windows

Version Controller: TFS, IBM Rational Synergy and Doors

Other Tools: Erwin, Microsoft Visio, Data Analysis, Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

WORK EXPERIENCE:

Sr. MSBI Developer

Confidential, Alpharetta, Georgia

Responsibilities: -

• Interacted wif Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS wif error handling.
• Worked wif different methods of logging in SSIS.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used some data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created the required Metrics and KPI's using DAX formulas.
• Developed, monitored and deployed SSIS packages.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Constructed OLTP and OLAP Databases.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields wif MDX code to meet additional measures needs dat are calculated from existing measures.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2008/2012, Windows Server, ProClarity/PPS, EDW, ODS, EDS, SSIS, SSAS, SSRS, Excel, T-SQL, DAX, PL/SQL, MS Access, Team foundation server (TFS), Informatica Power Center 9.5.1, Informatica Power Exchange 9.5.1, Mainframe VSAM & Flat Files, Power Designer

Sr. MSBI Developer

Confidential, Wallingford, CT

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Created Dashboards in Tableau.
• Created Various Chart reports using Power BI (DAX).
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules. Experience in creating joins for complex queries involving multiple tables.
• Implemented the Error handling in the Stored Procedures and SQL Objects and modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Involved in query optimization and tuning stored procedures for better performance.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked on various kinds of Transformations (Data Conversion, Lookup, Derived Column, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Slowly Changing Dimension, Union All etc.) in SSIS as per the clients Requirement.
• Experience in providing Error handling by using Event Handler for SSIS Packages.
• Worked wif different methods of logging in SSIS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008 and SSRS 2012.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment:SQL Server 2012/2014, SQL Server Management Studio, Enterprise Manager, Erwin, Windows Server, SQL Server Business Development Studio (BIDS), DTS/SSIS, SSRS, SSAS, MDX, SSRS, Power BI, Tableau.

SQL Server/BI Developer

Confidential, PHILADELPHIA - PA

Responsibilities: -

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS wif error handling.
• Worked wif different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Migrate reports from Dev to Production.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Used Tableau 8.2 and Power BI for creating Dashboards over the database system.

Environment SQL Server 2012/2014, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL, Tableau, Power BI

MSBI Consultan

Confidential

Responsibilities: -

• Involved in Design, Development and Deployment of the entire ETL solution of the Siebel Data Migration using Microsoft SQL Server 2005 SSIS Packages.
• Involved in building Cubes using Microsoft SQL Server 2005 SSAS for the Core Business Analysts.
• Analyzing Address & Name data for discrepancies and mismatch by each element by system.
• Involved in cleaning the Names and addresses in different systems by validating against the CAS USPS standardized data by using Quick Address Batch Tool.
• Used MS Access and Excel to prototype reports before developing wif SSRS and deploying on the report server.
• Experience in Integrated Oracle EBS to the HFM/Planning/Essbase applications using FDMEE as the ETL tool.
• Acted as a lead resource and build the entire Hadoop platform from scratch.
• Expertise in DevOps, Release Engineering, Configuration Management, Cloud Infrastructure, Automation. It includes Amazon Web Services (AWS), Ant, Maven, Jenkins, Chef, SVN, GitHub, Serena Products, ClearCase, Build Forge, Serena PVCS, CVS, Tomcat, JBoss, LINUX etc.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports
• Involved in Syncing up and Deduping Data in different systems by using Match IT Tool and SQL Scripts.
• Involved in generating different kind of data profiling reports and Extracts in the form of flat files etc.
• Designed, developed and implemented most complex logic of building Account Hierarchies among all the different Account Types such as Wire line and Wireless Customer, Service, Circuit and LEG Accounts.
• Designed, developed and implemented the Assets Migration Logic compatible wif the new Product / Bundles Structure in the Target by incorporating multi-level hierarchies. dis piece has been recognized and appreciated to a greater extent by the Oracle Partner.
• In-depth noledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Participated in Agile Scrum planning sessions as client transitioned from waterfall delivery methods and began educating team members on the nuances of DW/BI development via Agile Scrum.
• Involved in interacting wif the different ACS Stewards associated wif different data elements like Billing Name, Service Name, Billing Address, Service Address and Tax Address for defining business rules / config criteria required for cleansing.
• Designed, Developed and Deployed ACS Report using MSRS by migrating the existing Reports from DB2 Scripts / Shell Scripts

Environment Quick Address Batch, Match IT, MS SQL Server 2005/2000, Toad for DB2 Freeware, Aqua Data Studio 4.7-7.2 SQL Editor, Siebel 7.5 and 8.0, MSIS and MSRS, Siebel Data Model.

Confidential

SQl Server Developer

Responsibilities:

• Implemented a well-planned backup and restore strategy dat protects databases against data loss.
• Responsible for design, development and implementation of mappings/transformations based in source-to-target specifications, defining ETL (extract transform, load).
• Developed complex SQL queries, stored procedures, and DTS packages.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Worked on Setup and Workflow in FDMEE.
• Involved in designing and writing Stored Procedures, functions and packages using TSQL for SQL Server 2005.
• Development of oracle PL/SQL functions and procedures to Populate the Dimension and Fact table of STAR Schema.
• Used DBCC utilities to fix data corruption in application databases.
• Development of Business rules implemented as Constraints, Triggers and or Stored Procedures.
• Actively involved in Normalization & De-normalization of database.
• Installed and Configured SQL Server 2005 on servers.
• Designed DDL and DML for MS SQL Server 2005.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources.
• Optimized query performance by creating indexes.
• Created scripts for tables, stored procedures and DTS.
• Involved in writing SQL batch scripts.
• Writing TSQL statements for retrieval of data and Involved in performance tuning of TSQL.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DML for writing triggers, stored procedures, and data manipulation.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Monitor production Server Activity.
• Worked wif DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler and involved in tuning the database

Environment: SQL Server 2005 Enterprise, Windows Enterprise Server 2003, Erwin, Microsoft Visio, DTS, SQL Profiler, Query Analyzer.