SUMMARY:

• 11+ years of IT experience providing technical leadership on Data Warehousing projects involving Analysis, Design, Data, Modeling, Development, Integration, Implementation, Maintenance, Testing, and Production Support of Applications.
• Hands on experience in Big Data tools sets Hive, Pig, Sqoop
• Strong skills in IBM - DataStage 8.5/8.1/7.5/7.0/6.1 , PENTAHO, SQL Programming, Teradata, IBM DB2, PL/SQL, Debugging, Performance tuning and Shell Scripting.
• Expertise in Data Warehouses and Data Marts/Semantic layer using ETL (IBM-DataStage 8.5/8.1) and ELT (Teradata 15.10, UDB DB2 database) processes.
• Thorough knowledge of Data Warehousing Principles (OLTP and OLAP concepts) and architectural methodologies (Normalization, Dimensional Modeling) to build complex hybrid BI Solutions.
• Hands on experience in using Teradata Load utilities like (Fast Export, Fast Load, MultiLoad, and TPT) which was mainly used to refresh Stage/test Environment from Production
• Coded complex SQL and BTEQ Scripts to load data into Foundation/Aggregate tables.
• Conducted Performance tuning of SQL using Teradata DBQL details, Viewpoint and EXPLAIN, IBM DB2 Visual Explain and implementing aggregates, aggregate Join Indexes, compression,statistics, and SQL rewrites and suggested recommendation.
• Defined partitioning/Indexing strategy in Teradata and UDB environments
• Requirements capture, analysis and technical Design/Mapping applications using data warehousing applications.
• Expertise in performing Data Migration from various legacy systems to Confidential database (IBM DB2 to Teradata).
• Teradata 12 and IBM Datastage 7.5 Certified.

PROFESSIONAL EXPERIENCE:

Sr. Technical Lead

Confidential, TX

Responsibilities:

• Analyzing data patterns of Microsoft office usage across the enterprise using SQL Server SQL/T-SQL programming against Telemetry SQL Server database to understand the impact/Scope of testing of User defined applications(UDA) and Infopath.

Sr. Technical Architect

Confidential, MN

Responsibilities:

• Analyzing organizational data requirements and creating logical and physical data model using tools such as Visio and Erwin adhering to Teradata standards
• Document technical designs(HLD) to ensure clients needs are captured.
• Develop ETL/ELT code meeting technical specifications and business requirements according to the established designs and framework using IBM Datastage and Teradata SQL.
• Perform performance optimization and tuning of Teradata SQL and Datastage Jobs
• Performance tuning includes implementing aggregates, aggregate join indexes, compression, statistics, and SQL re - writes; along with semantic table modifications including Index changes.
• Reviewed SQL to ensure efficient plans and performance CPU thresholds. Worked closely with Microstrategy Architects to adjust SQL as necessary.
• Worked on ETL offload prototype from Teradata to HADOOP using Sqoop/HIVE/PIG.
• Developed reusable Unix shell scripts to schedule the Datastage and Teradata jobs in case there is Control M outage to meet the SLA.
• Worked in AGILE/DEVOPS environment
• Worked with Offshore and helped team in mapping Business requirement to technical specification and in code reviews to ensure smooth implementation of their User Stories.

Environment: Data Stage 8.5/8.7 PX, Teradata15.10, Hadoop 2.7.1, UDB DB2, AIX, UNIX Shell Scripting, SQL, Erwin 7.3.5, IBM CDC, Control M, Microstrategy.

ETL Data Lead

Confidential, Denver

Responsibilities:

• Independently lead Teradata/Oracle subprojects data warehouse solution implementation within complex projects.
• Defined the scope of projects or subprojects. Estimate time, cost, and resource requirements.
• Technical lead accountable for Enterprise customers, Third Party data Feed subject area s and SPOC for all technical issues related to coding, design, migration, and implementation
• Developed reusable Oracle PL/SQL procedure as maintenance routines which retain data for specific period of time.
• Developed ETL offloading framework in Hadoop using Sqoop, Hive.
• Designed and Deployed reusable UNIX Shell Scripts and these components were reused by other teams.
• Responsible for reverse engineering a project which is of medium complexity and was completely developed in UNIX Shell Scripting and Perl to Open source ETL Pentaho Framework. This helped client in managing new requirements to be retrofitted to the Pentaho Framework as client was familiar with this framework.
• Extensively used Oracle SQL loader and COSORT utility to load data from flat files and performing sort operations and join operations.
• Used UC4 for scheduling the jobs.

Environment: Pentaho 4.3.0, Oracle 11g, Hadoop, Teradata, SQL Loader,COSORT, UNIX Shell Scripting, Perl, SQL, UC4.

Sr. Technical Architect

Confidential Corporation, MN

Responsibilities:

• Designing and building Enterprise data warehouses, designing ETL architectures and procedures, performing analysis, SQL scripting, tuning and optimization on very large (multi - terabyte) databases.
• Analyzing organizational data requirements and creating logical and physical data flow diagrams and entity relationship diagrams using tools such as Visio and Erwin adhering to Teradata standards
• Document technical designs to ensure clients needs are captured.
• Develop ETL/ELT code meeting technical specifications and business requirements according to the established designs and framework.
• Perform performance optimization and tuning on new and/or existing data warehouse implementations.
• Designed and built Enterprise foundation Layer and Semantic Layer for Sales, Inventory, Instocks, Pricing, and Promotions; along with Dimensional subject areas consisting of over 250 views which enabled more than 100 reports with 3000 users accessing this data.
• Designed and developed Omni-Channel perspectives for Sales/Inventory and retrofitted legacy subject areas for backwards compatibility
• Performance tuned all above subject areas by implementing aggregates, aggregate join indexes, compression, statistics, and SQL re-writes; along with foundation table modifications including Index changes.
• Reviewed SQL to ensure efficient plans and performance CPU thresholds. Worked closely with Microstrategy Architects to adjust SQL as necessary. This exercise helped bringing down the CPU Cycles drastically and in turn system was able to handle new users and new applications without need for purchasing additional Teradata processing nodes which is expensive.
• Provided general design consultation regarding Best Practices and EDW approaches.
• Converted complex DB2 SQL to Teradata standards as part of migration from IBM DB2 to Teradata.
• Responsible for documenting Datastage and Teradata best practice document for populating source to landing,landing to staging and staging to Foundation/Mart as part of migration from IBM DB2 to Teradata which helped client reuse the best practice for other migration projects

Environment: Data Stage 8.5/8.7 PX, Teradata15.10, UDB DB2, AIX, UNIX Shell Scripting, SQL, Erwin 7.3.5, IBM CDC, Control M, Microstrategy.

Sr. ETL Developer

Confidential, MI

Responsibilities:

• Involved in design, analysis, development of High level Design, Detailed level Design and data integration mapping.
• Designed IBM DataStage ETL jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts which includes error processing, reprocessing logic, count match logic, restartability logic.
• Designed Shared container with RCP Technology for Populating data warehouse tables.
• Designed Job Sequences and scheduling jobs based on dependencies.
• Created reusable, wrapper scripts and count scripts for invoking DataStage jobs.

Environment: Ascential DataStage 6.0, DB2 UDB, AIX, UNIX Shell Scripting, SQL, AQT, Control M.