SUMMARY:

• A seasoned IT professional with over 12 years of experience in software industry in various phases of software development including analysis, design, development, testing, maintenance of multiple applications.
• Experienced as a Data Engineer, Data Analyst/System Analyst/Data Modeler/Data Profiler /SQL Developer with solid understanding of ETL methodologies.
• Strong understanding of Data Warehouse, AWS data pipeline, JDBC connectivity, Big data methodologies, OLAP, Data Modeling.
• Experience in using JIRA /Agile/Scrum methodology and well versed in writing user requirements.
• Developed web applications, RESTful web services and APIs using Python good knowledge of web services with protocols SOAP, REST. Have experience with Server less/PaaS technologies.
• Experience in developing applications using Amazon Web Services like EC2, Virtual private clouds (VPCs), Storage models (EBS, S3, instance storage), Very sound knowledge and experience of Amazon Web Services (AWS) (S3, EC2, IAM, RDS, EMR, CloudFormation and VPC.
• Acquired expertise in working on different relational databases - Oracle (versions 9i, 10g, 11g), SQL server.
• Expert in working on Stored Procedures, Functions, Packages, Views, Materialized Views, Indexes, Triggers, Cursors.
• Proficient in Tuning the PL/SQL code by using Explain Plan Table, Trace. Experienced in concepts of using Oracle Enterprise Manager for performance tuning, monitoring long running SQLs.
• Worked extensively in UNIX platform with expertise in shell scripts and hands on experience in using Control-M for job automation and Crontab as UNIX based automation
• 6+ years of experience in performing application impact analysis and extracting the functional rules from requirements and converting them into high and low-level designs.
• Experienced and have good understanding of Data Modeling (Logical and Physical Design of Databases), relational integrity constraints, and normalizations.
• Have worked in Retail, BFSI (cards and payment), Healthcare (Payer/Provider data), banking domain with experience in Retail and Investment Banking.
• Good communication skills committed team player and ability to deliver projects within schedule.

TECHNICAL SKILLS:

Operating System: Windows Vista/XP/7/8/10, Linux, Unix, OS X

Programming Languages: Python, SQL, PL/SQL, Unix, Shell scripts, PERL scripts, Spark, HiveVB6, Excel VBA

Databases & Tools: Oracle 11g/10g/9i, SQL Server 2016, Snowflake

Other Utilities: AWS, Toad, Alteryx, Crystal reports, Excel, Informatica, VSS, Github, Bitbucket, TableauPVCS, TSS

Methodologies: Waterfall, Agile, Safe

Year of Completion: (e.g. NIIT, APTECH, SSI Etc.)

PROFESSIONAL EXPERIENCE:

Confidential, Beaverton, OR

Data Analyst and ETL tester

Responsibilities:

• Interact with the business group, business analyst, data modeling team to gather and understand the business requirements within the NCAP.
• Create business work flow and end to end high level scenarios, which involves reviewing technical and business specifications and developing the methodology to achieve the Kaiser standard business solution.
• Participate in functional requirements review meetings which involve devising, strategizing, and explaining technical specifications and the way to achieve customized software solutions.
• Coordinate business and functional acceptance testing which involves ensuring technical specifications to meet business requirements
• Perform automated Unit and integration testing for the proposed requirements.
• Conduct code review ensuring the automated test cases are passed.
• Build deployment plans for each release, review with team members and co-ordinate with the Release management team on various dependencies related to the release of the software.
• Prepare of implementation pack document for production release.
• Validate Reports and data sets against source system.
• Document all report related activities including user requests, report specification, development, modification, testing and on-going production support.

Confidential, Beaverton, OR

Data Engineer

Responsibilities:

• Interact with the Confidential business group, business analyst, data modeling team to gather and understand the business requirements with in the Confidential GSM functions.
• Create business work flow and end to end high level scenarios, which involves reviewing technical and business specifications and developing the methodology to achieve the Confidential standard business solution.
• Participate in functional requirements review meetings which involve devising, strategizing, and explaining technical specifications and the way to achieve customized software solutions.
• Involve in developing the Advanced Manufacturing Dashboard and GSM data foundation using Oracle Pl/Sql, MSSQL, Snowflake, AWS, Python, Alteryx and Autosys.
• Develop cloud-based applications using Amazon Web Services and Storage models that can process high data volumes using features like EC2, VPC, EBS, S3, DynamoDB, SQS, SNS, Lambda, and Airflow.
• Develop Airflow Dags to automate the batch data load process in AWS Data Lake.
• Develop data transformation in AWS S3 using Apache Spark.
• Develop business consumption layer in Snowflake for Reporting Dashboards.
• Interface with other technology teams to extract, transform and load data for different sources using Datapipeline, SQL and Alteryx workflows.
• Build engineering on modern, cloud-based data processing technology stack.
• Build robust and scalable data integration pipelines using SQL, Python, Spark and data validation frameworks, job schedules with emphasis on automation.
• Build solutions using Unix Shell scripting and Python to automate data transfers between on premises to Cloud systems and vice versa.
• Maintain and deploy deliverables via Github/Bitbucket.
• Coordinate business and functional acceptance testing which involves ensuring technical specifications meet business requirements by providing advice and guidance to the software developers.
• Perform automated Unit and integration testing for the proposed requirements.
• Conduct code review ensuring the automated test cases are passed.
• Build deployment plans for each release, review with team members and co-ordinate with the Release management team on various dependencies related to the release of the software.
• Prepare of implementation pack document for production release.
• Validate Reports and data sets against source system.
• Document all report related activities including user requests, report specification, development, modification, testing and on-going production support.

Confidential, Naperville, IL

Data Analyst and developer

Responsibilities:

• Interacting with the business group, business analyst, data modeling team and user groups to gather and understand requirements.
• Design and create data reports and reporting tools to help business executives in their decision making.
• Perform application impact analysis and extracting the functional rules from requirements and converting them into high and low-level design components.
• Requirement gathering and coordination of the technical & business requirements with business associates.
• Oracle Data analysis, data validation and SQL query development.
• Involved in code development in various client applications to meet business needs of a proposed requirement.
• Conducting peer review during design, coding phases and perform Unit & integration testing for the proposed requirements, defects tacking and
• New database component development and enhancement as per project requirement.
• Migration of database objects from lower environment to higher environment.
• Preparation of implementation pack document for production release.
• Validate Reports and data sets against source system.
• Oracle Production job monitoring and L3 support.
• Documents all report related activities including user requests, report specification, development, modification, testing and on-going production support.

Confidential, Hagerstown, MD

Senior Developer

Responsibilities:

• Perform application impact analysis, arriving high and low-level estimates.
• Extracting the functional rules from requirements and converting them into high and low-level design components.
• Involve in code development in various client applications to meet business needs of a proposed requirement.
• Perform Unit & integration testing for the proposed requirements, defects tacking and maintaining test artifacts for quality and quantitative purpose.
• Responsible for creating and maintaining Analysis, Design and Development Plan for projects.
• Attending various meetings with business clients on requirement clarifications, design walk through sessions for the projects.
• Requirement gathering and coordination of the technical & business requirements with Offshore. Oracle Data analysis, data validation and SQL query development.
• New database component development enhancement as per project requirement. Oracle job monitoring and L3 support.
• Migration of database objects from lower environment to higher environment.
• Preparation of implementation pack document for production release.
• Validate Reports and data sets against source system.
• Design test plans, including test definitions and the creation of detailed solution test Scripts.
• Documents all report related activities including user requests, report specification, development, modification, testing and on-going production support. Work with other team members to explore methods for automation.

Confidential, Atlanta, GA

Senior Software Engineer

Responsibilities:

• Active part of Datamart Reporting team responsible for generating and delivering more than 1000 Monthly/Quarterly reports.
• Analyzing, designing and developing pl/sql packages for Inbound and Outbound Interfaces for New Clients. Requirement gathering and coordination of the technical and business requirements with Offshore. Handling post production issues using BMC Remedy and Mantis Bug tracker
• Involved in Extraction, Transformation and Loading of data and store the data into staging tables for further various analyses.
• Creating and maintaining run books for Weekly/Monthly /Quarterly Reports.
• Upgrading the inbound/outbound Reports developed for clients of AHM for Subsequent new releases according to the client requirements.