Saketh K Email & Phone Number

Indianapolis, Indiana, Us

 Design and develop ETL integration patterns using Python Develop framework for converting existing PowerCenter mappings and to PySpark(Python and Spark) Jobs. Develop Multiple ETL jobs using Informatica to Transform and load both Structured and unstructured data into Data Warehouse.  Confer with clients regarding the nature of the Data/information processing or Reporting/Analytical needs. Implemented pre-defined operators in spark such as map, flat Map, filter, reduceByKey, groupByKey, aggregateByKey and combineByKey etc. Use Relational Modeling and Dimensional Data Modeling using Star & Snowflake schema, De normalization, Normalization, and Aggregations.

London, Gb

• Design stable, reliable and effective databases• Optimize and maintain legacy systems• Modify databases according to requests and perform tests• Solve database usage issues and malfunctions• Liaise with developers to improve applications and establish best practices• Gather user requirements and identify new features• Develop technical and training manuals• Provide data management support to users• Ensure all database programs meet company and performance requirements• Research and suggest new database products, services and protocols

Worldwide, Oo

Lead Experience: Lead a team of developers and managed off-shore team Experienced in Informatica Power center Client tools• Involved in business requirement analysis and prepared functional requirement document Involved in the ETL technical design discussions and prepared ETL high level technical design document Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Aggregator, Lookup and Router transformations to extract, transform and loaded data mart area Created re-usable transformations/mapplets and used across various mappingsPerformed Data Wrangling using Pandas (Python) functionalities to explore data, deal with missing values, inspect duplicates, reshape and filter data. Wireless Network:•Analyzed the data and identified various metrics such as Avg. Commission Cost, Promo vs Non-Promo takers based on the Income Range, Line Tenure, Age group etc. for a leading wireless network. • Calculated the ratio of Promo Takers vs Non-Promo Takers and compared the National Average Ratio to the State Average Ratio.• Built dynamic and interactive dashboards using Tableau.Health Care and Life Sciences :• Performed root cause analysis of data issues by executing SQL queries with complex joins.• Involved in processing the data right from extracting it from Enterprise Data Warehouse that is hosted on Teradata and staging it. Then applying Data Quality checks in Delta and finally storing it in Target that is hosted on Netezza and SQL Server.Technical Environment: Informatica Power Center 9.6.1, Informatica Power Center 9.6.1, 10.1.0 Teradata, SQL Server, Netezza, DB2, Unix, Unix Shell Scripting, Control-M, Infogix

-Worked on OBIEE Business Model development in the finance sector using Dimensions, Aggregation Rules, and Time Series Functions. Developed OBIEE Dashboards, Analytics and BI Reports using filters -Involved in Data Modeling, Design Documents, and Data Warehouse. -Synthesized data and projected reports in order to make strategic decisions which improved efficiency by 15%- Involved in the performance tuning of SQL/PLSQL scripts based on explain plan- Supported during QA/UAT/PROD deployments and bug fixes.-Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS

Austin, Tx, Us

• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.•Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy. Sun Life Insurance: An insurance application that enables more than 1 million users to manage their accounts.•Wrote Test cases and executed test scripts in Data warehouse. .Wrote UNIX shell scripts for file transfer/archiving. Involved in Reviews as per ETL/Informatica standards and best practices Involved in Data Validation and Data Integrity checking..Managed test cases and client requirements using HP Quality Center. Involved in Data Quality ,Data profiling , Data Cleansing and metadata management Performing impact analysis and handling ETL change requests based on the business rules. Created design specifications for ETL coding and mapping standards. Wrote PLSQL procedures/Functions and called from Informatica Involved in test data preparation for all releases.

Managed a high quality bottled water plant with a turnover of $100,000 and daily output of over 5000 gallons complying with the municipality regulations and meeting the local demand. • Identified new potential customers and changes in trends through analysis of large data sets. Analyzed market structure, price forecasting process, investment return, supply and demand, and expanded areas of service which resulted in 20% ($20,000) hike in sales.• I have incorporated other channels of sustainability such as introducing Solar Power Panels which helped in reducing operational costs by 15% and ISO certification that helped in promoting the brand• Implemented cost cutting measures by regular maintenance of the purification equipment, improved inventory management, better employee scheduling and efficient handling of all the logistics.

Designed Asset Management Software(AMS) for the Central Railways using Adobe Flex that allowed Central Railways to reduce operational costs by 7% ($1.5million) with an enormous increase to their profit.Created checklists and UI designs and deployed them on the application to meet the expectancy.

Managed human resources of a secondary school with a staff of 100 members, 1500 students and an annual turnover of $200,000.• Recruited teaching staff and supervised teacher training maintaining the school’s accreditation by the state education department.•Introduced Merit Scholarships worth $5,000 for 50 students from local communities as a part of corporate social responsibility

Master’S Degree, Advanced Analytics

Bachelor’S Degree, Information Systems