SUKUMAR LAKINAM

Role : Technology Lead & Production Support Specialist

Client : T-Mobile

Roles and Responsibilities:

• Participated in business and functional requirements gathering, which involves review of existing systems configurations and operating methodologies as well as understanding evolving business needs.
• Data Modelling, Design and build data warehouse components in multi-tier architecture which comprises of stage operational data store and analytical data mart for each application.
• Design and develop end to end application for data warehousing projects by applying data transformations logics using industry's standard coding practices in Informatica Power Center
• Technical support during acceptance testing, responsible for all the quality checks in the projects and other technical document preparation
• Have worked in PL/SQL programs like stored procedures, functions, packages etc.
• Worked with production team to resolve data issues in Production database.
• Coordinated with various infrastructure, downstream - upstream teams for resolving issues during major incidents and certify operations are running successfully with no business impact.
• Coordinated with client in resolving the queries/issues faced and keeping the client, project manager updated on project status on periodic basis
• Provide value additions to application through continuous improvement initiatives such as perfective, preventive and adaptive activities
• Mapped data between source systems and warehouses.
• Managed team of 7 employees, overseeing hiring, training, and professional growth of employees.

Role : Sr. ETL Developer & Migration Specialist

Client : Blue Cross And Blue Shield Of Michigan

Roles and Responsibilities:

• Designing, Developing and Testing ETL Mappings, Mapplets, Workflows, Worklets using Informatica Powercenter 10.x, 9.x
• Worked in fast paced environment, under minimal supervision providing technical guidance to team members
• Been responsible for database schema design, development, integration testing and other projects that are necessary to help team achieve their goals
• Worked closely with multiple teams which are involved in data usage
• Identified efficiencies and ways to improve design and development processes
• Identified ways to increase efficiency of production support - found solutions that allow operations to better do their job without involving development resource time
• Developed mappings/reusable objects/transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Wrote Oracle packages and functions to implement business rules and transformations after staging is done.
• Worked with pre and post sessions, and extracted data from transaction system into staging area.
• Used Informatica Power Center 10.1 for extraction, loading and transformation (ETL) of data in data warehouse.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Used SSIS packages to load date from spreadsheet into database and also used packages to move data between databases (Oracle, flat-files) on different servers.
• Created SSIS packages to extract data from oltp to olap systems and scheduled jobs to call packages and stored procedures.
• Worked on different data sources such as Oracle, SQL, flat files etc.

Role : ETL Developer

Client : McKesson

Roles and Responsibilities:

• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
• Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
• Analyzed business requirements with Business Analyst to develop ETL procedures that are consistent across all systems.
• Involved in data modeling for SQL server databases to store data retrieved from flat files.
• Performed normalizing and de-normalizing flat files and loading them in SQL server.
• Created mappings/sessions and workflows for using Informatica version 9.x
• Installed and re-configuring and upgrading Informatica Powercenter Suite
• Used different types of tasks like decision, timer and event initial/bulk load process wait and command to maintain dependencies between sessions and load balancing within informatica workflow.
• Worked with various transformations like router, expression, SQL, lookup, normalizer, and aggregator in building complex mapping.
• Involved in designing procedures for getting data from all the source systems to data warehousing system.

Role : ETL Tester

Client: New York Financial Technology Partners

Roles and Responsibilities:

• Communicated technical information both verbally and in writing in simple terminology.
• Created comprehensive test plans, test scripts, and use cases to support testing objectives.
• Engaged internal and external customers during planning and test phases to answer questions.
• Established clear measurable goals and objectives for projects, prioritizing tasks for team members.
• Created plans for test method validation using research or field observations.
• Developed comprehensive test plans and workforce breakdown structures for complete systems.
• Reviewed, evaluated, and identified requirements for testability.
• Tracked test reports and failures determined by root cause data trends.
• Tested, identified and troubleshot problems with networks.

Role: Medical Coder

Client: Orlando Health Care Systems, Florida

Roles and Responsibilities:

• Correctly coded and billed medical claims for various hospital and nursing facilities.
• Reviewed outpatient records and interpreted documentation to identify diagnoses and procedures.
• Resourcefully used various coding books, procedure manuals, and on-line encoders.
• Interacted with physicians and other healthcare staff to ask questions regarding patient services.
• Assigned CPT, ICD codes, Modifiers for the procedures and diagnosis.
• Applied HIPPA guidelines to protect confidentiality and security of healthcare information.