OBJECTIVE:

• To seek a Sr Data Engineer / Sr BI Developer position in Data Warehouse/Analytics Environment.

SUMMARY

• Around 20 years of experience in analysis, design, development, testing and implementation of Datawarehouse/BI projects, Analytics, Reporting, database programming, Client - server and web-based applications.
• Digital Marketing Analytics & IBM Core Metrics for 3 years.
• Call analytics and reporting experience for more than 15 years
• Extensive experience in working with onsite as well as offshore teams
• Extensive experience in working with cross-functional IT and business teams
• Experience in working with Snowflake, Google Analytics, Big Query, Teradata, Oracle, SQL Server, MySQL and MS-Access Databases.
• Expertise in writing Snow SQL, BTEQ, SQL, PL/SQL, T-SQL, Stored Procedures, functions, triggers and packages.
• Design and development of ETL processes using DataStage, SSIS and DTS. Knowledge of tools such as Talend, Quality Stage and Informatica.
• Design and development of DTS packages for large data migration.
• Design and Development of Dashboards, Charts using QlikView and Cognos Analytics.
• Design and Development of DMR’s using Cognos Report Frame Work.
• Design and Development of QVD’s using QlikView.
• Design and Development of KPI’s in QlikView.
• Expertise in optimization and tuning of SQL Queries for improved performance by using explain plan, hints, indexes etc.,
• Designed and developed complex Crystal Reports using custom complex Formulas, Sub Reports, Crosstab, web, drilldown, graphical and pie charts, Parameter Passing, Text/CSV/Excel flat files extracts, custom Running Totals, Graphs and Charts, Drill Down Reporting and multiple Data Sources.
• Experience in Crystal analysis reports on OLAP cubes.
• Experience in working with Unix Shell scripts as well as Windows batch scripts.
• Experience in using job automation and scheduler tools such as Autosys.
• Experience in using tools such as Toad.

TECHNICAL SKILLS

Operating Systems: Windows and Unix

Databases: Oracle, SQL Server, MySQL, MS Access

Datawarehouse/ETL tools: Snowflake, Google Big Query, Data Stage, SSIS, SQL Server 2005, SQL Server Analysis Services, T-SQL, Talend, , Quality Stage, Informatica

BI/Analytical tool: Google Analytics, Cognos Analytics, QlikView

BI/Reporting tools: Crystal Reports, Business Objects,, SQR

Data Modeling Tools: Erwin, Oracle Designer

Database tools: SQL, PL/SQL, T-SQL, Toad

Scripting: Unix Shell programming, Windows batch programming, PERL

Languages: ASP, Visual Basic, Java script, VB Script, Developer 2000, Forms 6i and Reports 6i, PL/SQL Cartridges

IDEs: Visual Studio

PROFESSIONAL EXPERIENCE

Sr. Software Engineer

Confidential

Responsibilities:

• Requirement gathering and analysis by interacting with Product Managers & Data Governance team.
• Design and development of Functional Specifications by using Business requirements .
• Coordination with support groups
• Writing BTEQ’s Using SQL Assistant in Teradata .
• Writing Snow Sql Using Worksheets in SNOWFLAKE .
• Design and development of tables, views and other database objects.
• Design and development of ETL processes for data loading and migration using Data Stage.
• Design and development of DTSX packages for data migration.

Sr.Programmer Analyst

Confidential, Plantation, FL

Responsibilities:

• Requirement gathering and analysis by interacting with business analysts, account services and users.
• Design and development of Technical Specification Document by using requirements from Business Requirements Document.
• Participation in design meetings.
• Design and development of unit test cases followed by review with QA and Business Analysts.
• Coordination with support groups