Senior Data Analyst Resume

PROFILE SUMMARY:

Having over - all Software\Product Development experience of almost 8 plus years with leading companies in domains like Communications, Retail and Health Care.
Extensive knowledge in RDBMS with in-depth knowledge in T-SQL, Query Optimization and Performance tuning.
Have gained confidence and adequate knowledge in developing, designing and architecting ETL solutions in SSIS, developing reports in SSRS, Data-Warehouse, Business Analytics, Big Data Analytics, Cloud Infrastructure and Security

TECHNICAL SKILLS:

RDDBMS: SQL Server 2000/2008 R

Tools: SSMS, SSIS, SSRS, SSAS, Active Batch Scheduler, TFS, BIML

Languages: SQL, HTML

Cloud Technology: AWS

WORK HISTORY:

Confidential

Senior Data Analyst

Responsibilities:

Manage end to end complex database migration.
Worked on Index maintenance and performance tuning to ensure optimized data retrieval.
Migrated thousands of SSIS Packages to cloud server.
Replaced the existing third-party feature used in SSIS Packages with cloud technologies and developed a tool to automate the same.
Development of SSRS Reports for new requirements.
Migrating the existing SSRS Reports to cloud server.

Confidential

Senior Data Analyst

Responsibilities:

Design, implement and maintain all AWS infrastructure and services within a managed service environment Design, Deploy and maintain enterprise class security, network and systems management applications within an AWS environment
Implement process and quality improvements through task automation. Institute infrastructure as code, security automation and automation or routine maintenance tasks.
Perform data migration from on premises environments into AWS
Support the business development lifecycle (Business Development, Capture, Solution Architect, Pricing and Proposal Development)
Strong AWS knowledge on S3, EMR, ECS, EC2, Glue, Lambda, IAM, Kafka, RDS, Route 53, VPC, Code build, Code pipeline, Cloud watch, Cloud formation.
Strong in Hadoop Ecosystem and its major components and Pyspark, Presto, Airflow, Hive, Ranger, Livy, Zeppeli

Confidential

Senior Associate

Responsibilities:

Simplification of SQL Server Jobs by removing ActiveX Scripts and redeveloping in Active Batch Scheduler.
Migration of DB objects from
Development of SSIS Packages and batch files.
Created SSRS reports using Report Parameters,Drop-DownParameters, Multi-Valued Parameters, Drill down and Drill through reports and Charts.

Confidential

Programmer Analyst

Responsibilities:

Migrated a table containing 100million record to 4 million using latest SQL server functionalities and improved the performance drastically.
Performance tuning of Stored procedures and user defined functions
Generating reports using SSRS
Implementing table partitioning

Confidential

Programmer Analyst

Responsibilities:

Confidential

Programmer Analyst

Responsibilities:

Migrated databases from SQL 2000 to SQL Server 2008 R2.
Migrated reports from SQL Server 2005 to SQL Server 2008.
Used SSIS to deploy the changes in the new environment.
Created a batch file for automating the database migration by extracting values from XML file.