SUMMARY:

• Over 8+ years of experience in software development, designing and implementation of Standalone software application with major focus on Data warehouse and Database Technologies.
• Hands on Experience on Microsoft BI skills T - SQL, SSIS, SSRS, SSAS, DAX & POWER BI
• Expertise on development of MS SQL Server databases Technologies including DTS, SSIS, SSRS, SQL Server Profiler, and SQL Server Agents.
• Solid Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing decision Support Systems.
• Strong experience in logical and physical database design and development using Erwin and MS Visio.
• Experience in MS SQL Server Configuration, Performance Tuning, Query Optimization, Creating complex SSIS packages using appropriate control and data flow elements with SSIS standards like error handling, logging and working with package configuration files.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data, Crystal Reports and MS Excel spreadsheets.
• Experience working across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, unit testing, data validation, systems integration and user acceptance testing.
• Strong analytical and communication skills and ability to effectively communicate with all levels of management and staff.
• Proven knowledge and experience with all aspects of data management, including reporting, data analysis, analytics, and data modeling concepts and techniques.
• Exceptional hands on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Extensive Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance, Enhancements of Data warehouse, and ODS systems using Informatica 9.x/8.x, Oracle 11g/10g, DB2, SQL Server, Teradata, PL/SQL, and well versed with Data Warehousing Architecture Technology, Operational Data Store, and Dimensional Data Modeling.
• Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS ).
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Very good knowledge in scheduling and deploying reports on report manger.

TECHNICAL SKILLS:

Data Modeling: Data Modeling experience using Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimension tables, Physical and logical data modeling, and Erwin 4.1.4.

Databases: Oracle 9i/10g/11g, MS-Access, DB2, MS SQL Server, Teradata, Vertica, Hive, MySQL, and Sybase.

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, and exposure to SAS, JAVA, and PERL.

Domain Knowledge: Banking, Insurance, Healthcare, Spend Data Analysis, Sales and Warranty Analysis, Manufacturing, and Education.

Environment: Windows 98/NT/XP, Windows 7 Professional, UNIX (AIX), and Linux.

Miscellaneous: MS Office, Visio, Hyperion, Toad, Control M, Cognos, Business Objects, UC4, OBIEE, ODI, Brio, and Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Data Architect

Responsibilities:

• Interacted and coordinated with many departments to gather requirements and to assure satisfactory data content, quality and data integrity.
• Collaborate with business leaders to analyze critical data/drivers, document and translate business requirements into technical, scalable specifications
• Design, develop, test, and document new reports and dashboards
• Translate non-technical requirement into technical business requirements
• Deliver training on data and analytics tools
• Evaluate and enhance existing reports and dashboards
• Create dashboards and reports for internal and external clients to improve efficiencies and promote growth
• Define and document business requirements for new metrics and reports

Technologies Used: UNIX, Hadoop, Hive, Teradata SQL Assistant, Vertica, and Power BI, MS Excel, DAX.

Confidential, Los Angeles, CA

BI Consultant

& Improve the performance of reports.

Responsibilities:

• Interacted and coordinated with many departments to gather requirements and to assure satisfactory data content, quality and data integrity.
• Collaborate with business leaders to analyze critical data/drivers, document and translate business requirements into technical, scalable specifications
• Design, develop, test, and document new reports and dashboards
• Translate non-technical requirement into technical business requirements
• Deliver training on data and analytics tools
• Evaluate and enhance existing reports and dashboards
• Create dashboards and reports for internal and external clients to improve efficiencies and promote growth
• Define and document business requirements for new metrics and reports
• Ensure accuracy and integrity of data and reporting applications through detailed analysis, efficient coding, writing clear documentation processes, identifying and resolving problems as they arise
• Review and write complex SQL queries and develop stored procedures and functions in SQL
• Perform ongoing monitoring and refinement of reports and BI solutions
• Ability to work effectively within competing deadlines with minimal guidance
• Interact professionally and collaborate with a diverse group including executives, managers, and subject matter experts
• Created SQL test scripts to verify and validate the data on staging database against the business requirement.
• Used Power BI to create various analytical reports and Dashboards to help management identify critical KPIs and facilitate strategic planning.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Used TFS to keep track of the history, merging code between the different versions of the software, check-in/check-out options.

Environment: SQL Server 2008/2012, SSIS, SSAS, DAX, POWER BI, SSRS, Excel, T-SQL, PL/SQL, MS Access, Team foundation server (TFS), Flat Files, Power Designer

Confidential, New Jersey, NJ

BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
• Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.
• Migrated packages from SQL Server 2008 to SQL Server 2012.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• 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.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints,SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: SQL Server 2008/2012, Windows Server, SSIS, SSRS and TFS, ProClarity/PPS

Confidential, Latham, NY

BI/MS SQL Developer

Responsibilities:

• Involved in the Installation and Configuration of SQL SERVER 2008 with latest service packs
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension (Task Factory Tool).
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output by TF Error Output Description (Task Factory Tool).
• Identifying the mapping issues and discussing them with business analysts in team.
• Handled the database components (Code migration, Change control) for application releases.
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.

Environment: SQL Server 2008/2005, Windows Server 2003, SSIS, SSAS, SSRS and TFS, ProClarity/PPS, EDW, ODS

Confidential, San Francisco, CA

BI/DW Developer

Responsibilities:

• Involved in complete SDLC life cycle.
• Extract Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load Confidential package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created SSRS Reports on the top of the cube using some MDX queries.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Migrating COGNOS reports to SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, EDW, ODS