SUMMARY:

• 8+ years of experience in Software Analysis, Design, Development, Testing and Implementation of working withBusiness Intelligence tools like MSBI (SSAS, SSIS, SSRS)/SQL Developer.
• Hands on experience with all phases of Software Development Life Cycle (SDLC).
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables using Analysis Services
• Developing OLAP cubes using SSAS 2005/2008/2012 and Expertise skills in creating calculated measures and dimension members in SQL Server Analysis Services (SSAS) using Multidimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Generated different reports tools Pentaho, in SSRS creating datasets as parameterized stored procedures & OLAP cubes.
• Conducted business requirements gathering meetings, designed and monitored the construction of ETL processes, and documented the data/ETL mappings.
• Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, and multicast, Union All, Merge Join, Merge and SCD to load data into SQL Server destination.
• Used Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Designing packages.
• Strong Experience in Creating, Configuring, and Deploying SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from SQL Server, Access, Excel, Flat Files and XML using, SSIS.
• Proficient in ETL design concepts including Change Data Capture (CDC) and Slowly Changing Dimensions (SCD), and performed DTS & SSIS package monitoring, debugging, and performance tuning.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in building efficient SSIS packages for processing fact and dimension tables with complex transforms and SCD type I and type II changes.
• Provide technical enablement to clients developing BI solutions with Power BI.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Designed and monitored the construction of SSRS reports and hosted them on SharePoint/Native Mode.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008/2012.

TECHNICAL SKILLS:

Reporting Tools: Microsoft BI (SSRS, SSAS, SSIS).

ETL Tool: Microsoft SSIS.

Databases: SQL Server 2012, Oracle 10g/ Oracle 11g, MS Access, Teradata.

Programming Languages: T-SQL, PL/SQL, JAVA, C, C++.

Other Technologies: ErWin2.5, Oracle Enterprise Manager, Microsoft SharePoint Designer 2007/2010, Power BI, Microsoft InfoPath Forms 2007, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, CT

BI Developer (MSBI)

Responsibilities:

• Designed and monitored the construction of the SQL Server Business Intelligence enterprise data warehouse.
• Generated Tabular Model in SSAS, partitioned, used different storage techniques, created DAX, MDX queries to retrieve and manipulate data off them.
• Designed complex SSAS Multidimensional cubes using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012/2014 and in adding calculations using MDX.
• Involved in writing MDX Queries for Analytical and Reporting purposes
• Created various KPIs, actions, aggregations for proper analysis of data in the cubes.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Processed OLAP cubes with various processing options depending on the requirement.
• Designed and monitored construction of the ETL processes, and provided the ETL mappings in the design document.
• Developed automation scripts which used REST APIs to extract data from blob storage of Azure Cloud Services.
• Created and Maintained SQL Server Agent Jobs for SSIS Packages.
• Customized sites on SharePoint Portal and hosted the SSRS and Power Pivot reports on to SharePoint.
• Created Power view reports using the Tabular SSAS models in Excel.
• Scheduled Reports using subscriptions in SharePoint.
• Provided 24/7 production support for Business users.

Environment: Microsoft BI (SSAS, SSRS, SSIS -2012/14), MDX/DAX, SharePoint 2007/2010, SQL Server 2012/2014, Business Intelligence Consumer Services.

BI Developer (ETL Developer)

Responsibilities:

• Involved throughout the Complete System Development Life Cycle
• Developed Various Mappings with the collection of all Sources, Targets, and Transformations.
• Created SSIS packages to clean and load data to the data warehouse.
• Proficiency in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Data Tools, and Business Intelligence Development Studio.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, and CSV files to data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Migrated DTSX packages from SQL Server 2005 to SQL Server 2008.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated and created a table to save dirty records.
• Created mappings for conditional split, merge, merge join, export column, import column, audit and SCD transformations.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Created views, tables and generated TSQL script for application, and created indexes for better performance.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Tested the data with complex queries, joins and sub queries. Used various transformation tasks to create ETL packages for data conversion.
• Understood the design of star schema and snow flake schema.

Environment: MS SQL Server 2008/2008R2, Microsoft Visual Studio, Business Intelligence Development Studio, SQL Server Data Tools, SSIS, SSRS, MS-Access, MS-Excel 2010, Windows Server 2008 R2/2008, Windows 7.

SQL Server Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.
• Provide database coding to support business applications.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Worked with internal and external clients for import and normalization of third-party data.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Provide technical support and guidance to staff and clients.
• Generate reports and spreadsheets detailing database changes and performance.

Jr. Developer

Responsibilities:

• Create Entity Relationship (ER) Diagrams to the proposed database
• Create database objects such as tables, views, stored procedures, Triggers etc.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Create functions to provide custom functionality as per the requirements.
• Be aware of potential blocking, deadlocking and write code to avoid those situations.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert Experience in Normalization, De-normalization.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio.
• Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.

Environment: SQL Server 2005/2008 MS-Access, Windows 2003 Server, Microsoft Office 2003.