SUMMARY

• 8+ years of experience in analyzing, implementing and supporting enterprise resource planning (ERP), decision support and business intelligence (BI) applications.
• Expertise in database development (SQL, PL/SQL, T - SQL, NoSQL), object oriented programming (C#, C++, Java), Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Strong ability to analyze user requirements.
• Deployment of information systems in banking, oil & gas, health care and manufacturing industries.
• Sound knowledge of design techniques using entity relationship diagramming (ERD) and Unified Modeling Language (UML).
• Excellent ability to find creative solutions to complex problems, coupled with an ability to explain difficult concepts in simple terms and to work from a pragmatic business perspective.

TECHNICAL SKILLS

Operating Systems: DOS, LINUX, MS Win 95/98/2000/XP/Vista/7, Mac OS

Databases: Oracle 10g/9i/8i, SQL Server, MS Access, My SQL, NoSQL

Languages: C#, C++, Java, PHP, HTML, XML, JSON, JQuery, T-SQL, PL/SQL, DAX, MDX

Tools: SSMS, SSIS, SSAS, SSRS, PowerPivot, MS Office Suite, MS Project, MS Visio, Visual Studio, MS Azure

Hardware: Cisco router, Cisco Switch, Servers, EMC storage

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

• Implementation of Hadoop solution using MS Azure (HDInisight) to architect a solution for big data.
• Migration of existing database to MS Azure platform to solve the problem of scalability due to increasing data size.
• Implementation of Dimension Data Warehouse including ETL Architecture, Data Warehouse, OLAP Cubes and Reporting.
• Deployment of database in SQL Server Virtual machines (MS Azure platform).
• Database creation, performance tuning, setting up database auditing and encryption, implementing high availability, documentation and troubleshooting.
• Migration of master data from legacy systems to Dynamics AX using SQL from Account Payables, Accounts Receivables and Equipment Inventory. Also built dashboards using SSRS and SSAS.
• Led global teams across multiple countries (India, Mexico and Philippines) during the implementation of custom software projects and Business Intelligence solutions utilizing Microsoft technology, providing clients with simple framework to analyze and evaluate the performance of the organization at different levels.

Confidential

Business Intelligence Developer

Responsibilities:

• Designing, building, enhancing and supporting Microsoft Business Intelligence solutions and assuring smooth ongoing operation of the solutions.
• Designing and implementing data warehouses and data marts using components of Kimball Methodology like Data Warehouse Bus, Conformed Facts and Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema etc.
• Designing and implementing Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Exception Handling etc. using SSIS.
• Develop and test data extraction, transformation and loading processes.
• Provide intuitive data visualization of PowerPivot model and SSAS tabular mode database using PowerView.
• Data warehouse design using Kimball Dimensional modeling.
• Work together with the Information Designers to identify and validate data required from various source systems.
• Map the source data to the target data structures designed for the data warehouse.
• Find and implement best practices within the team.
• Implement business rules as defined and specified by Business Partners through the functional specifications which fall as part of the transformations.
• Define consistent business rule for specific data.
• Identify and implement any transformation or conversions required to maximize consistency and usability of the data.
• Reports development using SSRS and PowerPivot.
• Identify, design and establish technical requirements.

Confidential

ETL Developer/Project Manager

Responsibilities:

• Designing, building, enhancing and supporting Microsoft Business Intelligence solutions and assuring smooth ongoing operation of the solutions.
• Designed and customized data models for data warehouse supporting data from multiple sources on real time.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using SSIS and loaded data into target by scheduling the sessions.
• Created SSIS packages to extract data from Excel files, MS Access files using Pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task, etc. to generate underlying data from the reports and to export cleaned data into data warehouse.
• Responsible for envisioning and implementing data governance and privacy regulation.
• Created data governance and privacy policies specifying implementation.
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes.

Confidential

Business Intelligence Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.
• Created numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Extracted data using Query Analyzer and DTS packages.
• Tuned and optimized SQL statements, stored procedures and views.
• Wrote complex SQL queries and could quickly understand requirements for complex queries and procedures.
• Configured, patched, tested, and supported all MS SQL Server database instances.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Scheduled Jobs to call the packages and Stored Procedures.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Confidential

MS Business Intelligence Developer

Responsibilities:

• Created database, tables and relationship constraints using T-SQL scripts.
• Developed T-SQL stored procedures, functions, according to the specs, joining tables and views.
• Worked with business users and business analyst for requirements gathering and business analysis.
• Involved in the analysis of the user requirements and identifying the sources.
• Extracted Data from various sources like Data Files and exported into data warehouse using SSIS.
• Created database, tables and relationship constraints using T-SQL scripts.
• Developed T-SQL stored procedures, functions, according to the specs, joining tables and views.
• Designed and created SSIS packages to load data into data mart.
• Analyzed, revised and redesigned existing reports.
• Implemented trigger to maintain data integrity and consistency.
• Maintained User databases and system databases.
• Developed detail and summary reports using SSRS.
• Provided technical support.