Principal Consultant Resume New York, NY - Hire IT People

TECHNICAL SKILLS

Proficient in: UNIX shell scripting, SQL, PL/SQL, ETL

Experience with: Sales Force, Business Objects

Databases: Teradata, Oracle 8i/9i/11g, SQL Server 2008

ETL Tools: Informatica Power Center 8x/9x, Data Stage, BTEQ, MLOAD, FLOAD, TPUMP, Fast Export

Big Data Technologies: Hadoop, HIVE, Scoop

Job Scheduling Systems: Tivoli, Dollar Universe

Version Control: Kintana, Synergy, GIT

PM/Defect Tools: JIRA, HP ALM (QC), ServiceNow, TCM, Serena

Platforms: Windows, Linux, Hadoop (Cloudera)

PROFESSIONAL EXPERIENCE

TEMPPrincipal Consultant

Confidential, New York, NY

Responsibilities:

Worked in Wealth Management for multiple projects like 408b (2) Fee Disclosure and Annual Fee Disclosure for Small Business Retirement Accounts, Conversion, Mutual Fund Trails, AMEX Credit Cards, Bank Deposit Program and Sales Force Integration.
Interfaced with business users to gather requirements.
Developed and delivered efficient & cost - effective technical solutions to meet customer business requirements.
Defined requirements into technical design and designed the project architecture in optimized way to manage high data volume to map to sub systems.
Created ETL mapping document and implemented ETLs having complex business rules using Informatica Powercenter 9.5.1 and Teradata.
Reduced batch execution time by 20% after performance tuning of various SQLs and ETLs.
Coded UNIX shell scripts for scrubbing and parsing of data which can be reused in other projects.
Worked on design approach and Hadoop environment set up, developed HIVE and Informatica jobs to load data into Sales Force CRM.
Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
Conducted weekly review of design/code/test deliverables, reducing rework by 25% and eliminating wasted cycles.
Performed root cause analysis on productions failures and resolved issues.
Managed offshore team and onsite liaison work with various stakeholders.
Created technical Runbooks and TWS documents for scheduling the jobs.

Consultant -Genpact Headstrong Capital Markets

Confidential

Responsibilities:

Analyzed all source structures and working with data modeling team for target table’s creation.
Created Tables script with appropriate Primary Index, Secondary Indices and Partitions.
Used Teradata utilities like BTEQ, FLOAD, MLOAD and Fastexport for data conversion.
Developed Informatica ETLs using various transformations for data cleansing and data loading as per business requirement.
Reusable transformations, mapplets and worklets are built wherever redundancy is needed.
Performance tuning is performed at Mapping Level as well as Database level to increase data throughput.
Involved in supporting and maintaining UNIX shell script jobs.
Worked with QA & UAT teams for fixing issues and getting signoffs.
Wrote SQL scripts and create Business Object reports to support weekly/Monthly Adhoc Requests.

Software Developer

Confidential

Responsibilities:

Involved in Environment set up for testing in Confidential EDW CQA project.
Worked on automations using BTEQs for the environment sanity checks.
Actively worked on writing SQLs for functional testing, data flow validations and dev support for multiple modules.
Worked with Oracle SQL, PL/SQL procedures and functions, stored procedures and packages within Informatica mappings in Confidential EDW2B project.
Development of new Dollar Universe code for dependency changes.
Migration of code into testing using Kintana.
Design and development of DataStage jobs for Data In - Confidential Transformation TR2 project.
Resolved DataStage job related issues and Teradata issues.
Prepared test cases and executing them using Mercury Quality Center 9.0.
Assisted in System testing and System integration testing.
Defect reporting and defect tracking.