SUMMARY

• Result - oriented professional offering 12 years of Cross functional experience and hands on experience in Business Intelligence development and Business Analysis.
• Performed various roles in Financial, Medicare and telecom domain.
• Knowledge in investment banking and capital markets.
• Strong Experience in MS SQL Server 2015, 2013,2012/2008R2/2008 with BI in SSIS/SSAS/SSRS.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional and Dimensional modelling (Star and Snowflake schema) Concepts.
• Exposure of working with various Business Intelligence tools SSRS, Business Objects, Webi, Crystal Reports X and XI and Actuate erd prod v8, SSRS.
• Extending Data Warehouse experience using Informatica Power Centre 9.1/8.6/7.1.1 and also hands on experience in Oracle, SQL Server, Sybase, and DB2 Databases too.
• Hands on experience in Big data tool like Sqoop,HDFS, Hive, Spark, Scala.
• Extensive knowledge with Dimensional Data modelling and BI methodologies.
• Well versed with programming languages like C#, .Net, ASP .Net, XML, HTML.
• Worked in Agile environment and also played scrum master role for a considerable period of time.
• Experience in writing SQL, T-SQL, PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Significant work experience in On-site/Offshore co-ordination, Client Interfacing and Technical Leadership.
• Excellent communicator with emphasis on clearly presenting information and developing strong interpersonal relationships.

TECHNICAL SKILLS

Languages: SQL, PL/SQL,T-SQL, UNIX shell script,.Net, C#, ASP .NET

Operating Systems: Windows 98/2000/XP, 2007

Relational Database: ORACLE10/11g, SQL Server 2005, 2008 R2,2012, MS Access, Sybase, DB2

Reporting Tools: SSRS, Microstrategy, Crystal Reports -10, Business ObjectsX1/R2Business Objects X1R 3.1, Qlikview, Actuate erdPro v 8, SSRS

ETL Tools: SSIS, SSAS, Informatica Power Center v7.1.1, 8.8, 9.1, Spark, Scala, Hive, Sqoop, HDFS

Other Tools: Toad, PL/SQL Developer, QTODBC,WINCVSTortoise SVN, putty, Tidal Scheduler, JIRA, TFS, Confluence

Data modeling: OLTP, OLAP, ROLAP, MOLAP, Star SchemaSnowflake Schema, Dimensional ModelingData Modeling, Physical and Logical Data Modeling

PROFESSIONAL EXPERIENCE

Confidential

Senior DW and BI consultant

Environment: SSIS 2013/2015, SSAS, SQL Server 2014, Microstrategy,. Net, C#, Big Data, Hadoop, HDFS, Hive, Sqoop

Responsibilities:

• Contributed to the analysis, design and development of the overall TTS system with key involvement being in Launch management Dashboard (LMS)
• Wrote an independent process using all the latest technology tools like SSIS 2015 and Sql Server 2014 to build end to end process to consume source data and delivering an input to one the key dashboard in LMS.
• Working with BA and Business understanding and articulating the requirements into meaning technology code.
• Did POC to enhance analytics functionality using Big Data and Hadoop, Sqoop and hive.

Confidential

Analyst

Environment: SSIS, SSRS,SSAS, SQL Server 2008 R2, 2012, . NET, C#, ASP.NET,Big Data, Hadoop.

Responsibilities:

• Contributed to the analysis, design and development of the overall system that involved design of database, creating scripts, tables and ETL components SSIS, SSAS and SSRS reports
• Led the successful development and delivery of compliance reporting for AMCB(TD America) which included SQL Server Integration Services, SSAS Cube, SSRS Reports and a .Net Portal.
• Worked on leading and hands on development for various DCSR initiatives within TD e.g. Direct inverting Account Opening, Mutual Fund Retention writing Design Documents, modeling, ETL procedures, MDX and Reports.
• Worked with team of Developers to come up with a framework to extract multiple files (Approx. 100) from different source systems and delivered it to EDPP (TD HADOOP)
• Enhanced the functionality of front end application using ASP.NET and C#.

Confidential

Project Lead

Environment: Informatica 9.1, Oracle 11g, UNIX, Business Objects, Webi Intelligence, Qlikview.

Responsibilities:

• Contributed to the analysis, design and development of the overall system that involved design of database, creating scripts, tables and ETL components.
• Worked on Dimensional modelling design and Physical database modelling, BI methodologies.
• Responsible for running Architectural Review Sessions.
• Working with business to understand the concepts of solution building in investment banking.
• Worked on Informatica Power Centre tool for ETL logic and Business Objects and Webi for BI.
• Experience in writing PL/SQL procedures for processing business logic in the database.
• Worked on Universe Designing in Business Objects and also involved in report designing.
• Hands on working experience in Qlikview Data Visualization.
• Communicate activities/progress to the product owner.
• Designed and developed a robust delta data extraction and load process in order to send delta feeds to target applications.
• Developed Shell scripts for housekeeping and file management activities.

Confidential

Offshore Project Lead

Environment: SSIS, SSRS,SSAS, SQL Server 2008 R2.

Responsibilities:

• DW/BI Offshore Project Lead
• Actively involved in Business Requirement analysis, Design Process.
• Worked on dimensional model design.
• High level ETL Framework/Flow design.
• High Level Business Objects Universe and reports design.
• Involved in writing T-SQlL, PL/SQL procedures for processing business logic in the database.
• Performance Tuning by using Explain Plan in SQL Server

Confidential

System Developer and Track Lead

Environment: Actuate Reporting Tool, Crystal reports 10 and SSIS, SSAS, SSRS, 2008 Oracle 11g, Sybase, DB2, SQL SERVER, UNIX,Business Objects

Responsibilities:

• Working as a lead in this project and involved in the Business Requirement analysis, Design Process.
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application SME’s.
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• BI and ETL development on different technology platforms including MS SQL server, SSIS,SSAS, T-SQL,PLSQL, Oracle v9 (SQL and PLSQL),Crystal reports and Business Objects
• Involved in the Development and documentation of complex Informatica Mappings/sessions and system testing as per the business requirement.
• Create and run the Actuate, Crystal Reports and CSVs
• Worked on most of the DB - SQL Server, Oracle, Sybase, DB2, Sales force and stored procedures in SQL and T-SQL too.
• Implementation of Packages to deploy the reports in the PROD Servers.
• Incorporating Client Feedback.
• Working with BA to understand the investment banking product that was built.
• Regular and Direct Client interaction.
• Have also worked as a BA for a short term project while being at onshore.

Confidential

Technical Analyst

Environment: Oracle 9i, Informatica 7.1.1, Crystal Reports 10, Business Objects and Webi

Responsibilities:

• Involved in the Business Requirement analysis, Design Process and writing technical specs.
• Used Informatica as the tool for extracting data from the flat files, relational databases and transforming the data according to the target database and performed loading.
• Worked extensively in creation of various reports in crystal reports and business objects.
• Implementing PL/SQL procedures and optimization of the SQL Code.

Confidential, Boston, MA

Technical Analyst

Environment: Oracle 9i/10g, Informatica (v7.1.1)

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Imported Sources and Targets to create Mappings based on business logic and developed Transformations using Power center Designer. Used Informatica Workflow Manager, Workflow Monitor to create sessions and batches.
• Implementing the changes required and Unit testing them.
• Tuning the queries.
• Completed documentation in relation to detailed work plans, mapping documents and high-level data models.