SUMMARY:

• 14+ years’ of diverse and extensive experience in IT industry
• Implemented complex multi - million dollar projects, with global implementation, rapidly evolving requirements, stringent timelines and high pressure, using waterfall and Agile Scrum execution models
• Experienced as Data Architect/Technical Manager with demonstrated success in the execution and delivery of end-to-end Data Warehousing and Business Intelligence programs.
• Hand on experience in AWS Platform and Bigdata technologies
• Provided technical direction and solution for multiple project initiatives
• Has worked on Telecom/Cable Domain for 9+ years using technologies like Pentaho, Data stage, Informatica, Tableau, Grafana, Elastic search and banking domain for around 2 years using the technologies MSBI, Oracle.
• Strong communications skills

TECHNICAL SKILLS:

AWS Services: EC2, S3, ELB, RedShift, RDS, Athena,Lambda

Languages: Python, Pandas, Pl/Sql

ETL: Pentaho, Informatica, DataStage, SSIS

BI/Reporting Tools: Tableau, Grafana, OBIEE, Business objects

Databases: Oracle, SQL Server

Scheduling Tools: UC4, Oracle DAC

Others: Elastic Search, Kibana, Toad

PROFESSIONAL EXPERIENCE:

Confidential

Technical Project Manager

Responsibilities:

• Creation of user stories in rally, tracking them to closure, highlight risks and issues.
• Responsible for the delivery of the projects for each sprint/release
• Manage end-to-end delivery and guidance to the team on resolution to critical issues
• Responsible for coordinating with onsite offshore teams on regular basis for successful delivery of the project.
• Interact with Finance teams to understand the agreement with the Affiliates and identify the high level requirements
• Understanding the business flow and identify the required data sources.
• Developed Python scripts to read data from Elastic search environments and to load into relational store for joining and further data analysis
• Created Python scripts to automate AWS services, which include web servers, ELB, Cloud front distribution, database, EC2 and database security groups, and S3 bucket and application configuration.
• Developed API for using AWS Lambda to manage the servers and run the code in the AWS.
• Implemented AWS solutions using EC2, S3, RDS, EBS, and Elastic Load Balancer, Auto scaling groups, optimized volumes and EC2 instances.
• Implemented ELK (Elastic Search, Log stash, Kibana) stack to collect and analyze the logs produced by the spark cluster.
• Performed advanced procedures like text analytics and processing, using the in-memory computing capabilities of Spark using Python.

Confidential

Technical Project Manager

Responsibilities:

• Analyze and identify major systems to define the source of truth for each customer attribute
• Involved in identifying the correlation points between various systems like billing, ordering etc.
• Involved in system architecture design and development
• Design, develop and deploy work items for each sprint
• Work with the customer to understand new requirements and seek clarifications
• Work with business users to provide quick resolutions to production incidents
• Understand the requirements from other systems and onboard them as new users
• Identify the data provisioning requirements for the new systems and accommodate in the model

Confidential

Telluride Data migration

Responsibilities:

• Lead the huge data migration of around 100 million customers and the transaction. Involved more than 900Gb of data with no down time
• Interacted with the Business Users & Enterprise Data Architects in the analysis & design of migration model that is required for solid implementation & ensuring that it meets the business requirements
• Analyzed the source system for integrity issues
• Responsible for preparing the migration approach and strategy for migrating data.
• Lead the team of shell script developers
• Created the outer framework to control the flow of data
• Shell scripts were developed with coding standards for better understanding
• Used awk, sed and perl wherever possible for better performance
• Created scripts to connect to Teradata and MySQL from UNIX
• Used FastLoad and MultiLoad utilities in Teradata for quick loading
• Used BTEQ* command line interfaces to connect to Teradata databases
• Developed bteq, infile and outfile scripts
• Implemented Email notification inside scripts that keeps the user informed about the job load status
• Configured crontab for automation
• Wrote complex procedures in Teradata to accomplish required objectives

Confidential

Senior Developer

Responsibilities:

• Perform the source system analysis to identify the data mappings and data flow.
• Preparation of Source to Target mappings between the source and target systems
• Responsible for the design and development of ETL (SSIS packages) and Oracle SQL PLSQL blocks.
• Responsible for preparing scripts and ETL blocks for one time data migration of historical data between the two systems.

Confidential

Senior Associate

Responsibilities:

• Project Planning Activities like - End to End Scheduling, Tracking, Defect prioritization, Resource Planning, Implementation, Communication planning, Career planning of team members
• Communication - Status Reporting, Dashboard reporting, Defect Analysis Report, External teams communication, Onsite-Offshore coordination
• Establish and enforce development processes to produce quality deliverables
• Analysis of the Change requests raised by the business and preparation of Technical Design document
• Identify the best fit data model prepare ETL and BI design document
• Customization of the Siebel provided OOB mappings both SDE and SIL based on the user requirements.
• Development of new SDE and SIL mappings, sessions and workflows to cater to the new business requirements
• OBIEE repository, hierarchies, levels and data security were set in the administrator and the fields required for presentation were brought into the presentation layer
• Extensively used OBIEE answers to develop the reports and dashboards required.
• Alerts were set in the dashboard to trigger mail to the managers or leaders if the target is not set.
• Developed Pl/Sql procedures for backfilling history data.
• Configuration of Informatica artifacts in Data warehouse Administration Console (DAC) as tasks.
• Creation of subject areas, execution plans in DAC and schedule the Informatica jobs
• Involved in ETL performance improvement design and development at offshore.

Confidential

Developer

Responsibilities:

• Designed the End to End ETL solution and played a crucial role in the Analysis and Design phase
• Design and development of the Near Real Time Reporting involving CDC in Oracle 10g and in Data Stage
• Involved in designing and developing jobs using Data Stage during the project’s development phase ensuring quality and compatibility of the code in keeping with Confidential ’s Quality standards and industry best practices.
• Involved in designing and developing Reports in Siebel Analytics and Oracle BI during the project’s development
• Helped with the successful deployment of the project and provided post-implementation and maintenance support.
• Involved in creating complex reporting functionalities like master detail report, parameterized report, drilling methodologies, conditional formatting etc.
• Created Chart reports increasing the readability of reports
• Defined Hierarchies in RPD to provide the users with Drill down option in reports.
• Implemented security at data level as well as object level
• Worked onsite for requirements gathering. Also done the offshore co-ordination from there
• Demonstrated capacity to successfully manage multiple tasks and deadlines.
• Responsible for managing and coordinating team members to successfully accomplish highly dynamic and time-sensitive requirements.

Confidential

Developer

Responsibilities:

• Data modeling and Development of data stage jobs.
• Data Analysis and Data Migration from EPICOR to Peoplesoft ERP on the Finance, CRM etc., modules
• Development of Cognos reports.
• Maintenance of the different modules.