Sr Data Analyst/developer Resume
Frisco, TX
SUMMARY
- 17+ years of IT experience in the Analysis, Design, Development, Implementing and Testing using Microsoft SQL Server and BI suite (Reporting, Development, UAT Environment).
- Strong technical experience in MS SQL Server development, SSIS, SSRS, Performance tuning, designing databases and Troubleshooting.
- Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing applications).
- SQL Server 2005/2008 R2/2014/2016 RDBMS database development including T - SQL programming.
- Excellent communication skills, analytical skills, understand business requirements in various domains.
PROFESSIONAL EXPERIENCE
Confidential, Frisco, Tx
Sr Data Analyst/Developer
Responsibilities:
- Developed and Implemented billing system.
- Create tables, stored procedures, views, functions, constrains and indexes.
- Created project workflow and test cases documents.
- Maintained, support and enhanced existing SSIS ETL process and stored procedures
- Worked on design, analyze and code review with Onshore and offshore team
- Worked on Agile environment with onshore and offshore team.
Environment: SQL Server 2014, SSIS
Confidential, Lisle IL
Sr Database Developer/SSIS/SSRS
Responsibilities:
- Created Power shell script to migrate 500 databases, tables, stored procedures, functions and views script on new environment
- Created dummy file to test SSIS packages on QA environment.
- Create tables, stored procedures, views, functions, constrains and indexes.
- Created project workflow and test cases documents
- Maintained, support and enhanced existing SSIS ETL process and stored procedures
- Maintained, support and enhanced SSRS reports and deployed on Production environment.
- Participated design, analyze and code review
- Worked on Agile environment
Environment: SQL Server 2016/2008R2, SSIS, SSRS, git, bit bucket, Jira, Confluence, Source tree
Confidential, Chicago, IL
Sr. SQL developer/SSIS/SSRS
Responsibilities:
- Worked on Performance tuning of stored procedure and long running T-SQL.
- Created index, stored procedure, functions, and tables
- Created and updated SSIS packages and deploy on QA and Dev server.
- Create SSRS tabular and drill down reports.
- Created T-SQL script to deploy on QA, UAT and Production server.
- Created Project Documents.
Environment: SQL Server 2014, Microsoft SQL server Integration Service, Microsoft Office, SSRS
Confidential
Sr. SQL developer/SSIS/Tableau
Responsibilities:
- Worked on Requirement Gathering, project and test case documents.
- Created and Modified Tables, Stored procedure and views based on Requirements.
- Created Table mapping and issue tracking documents for ETL process.
- Used SSIS Control flow tasks such as Execute SQL Task, For Each loop task, FTP Task, File system task.
- Used Data flow task, OLE Db connection, Derived Column task and Conditional split.
- Worked on SSIS Package variable declaration, deployment, logging and error handling process.
- Working on existing ETL process to enhance, bug fixing issue.
- Executing Last Touch, Path Finder, MSR, BAC, Marin/Search and IAS Job scheduling using SQL server Agent.
- Created dashboard using parameters, groups, and calculations and drill down and drill up in worksheets.
- Developed Tableau workbooks to perform year over year, quarter over quarter marketing data analysis.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Worked on project requirement, analysis, design, code and test process with VP, Director, Associate director and team members
Environment: SQL Server 2008R2/2014, Microsoft SQL server Integration Service, Microsoft Office, Tableau.
Confidential, Elk Grove village, IL
Senior SQL Developer/SSIS
Responsibilities:
- Created tables, stored procedures, and views in T-SQL and MY SQL.
- Worked in creating complex stored procedures, cursors, tables, views, joins, statements and complex T-SQL.
- Created tables, indexes, and constraints to improve performance of slow running SQL.
- Analyzed, documented, and implemented requirements.
- Interacted with the project manager, technical project manager, director, and team members for project meetings, work status, project analysis, design, test case and execution.
- Created customized ETL tool using Amazon Data pipeline, SSIS, C#.net, MYSQL, JSON, XML, T-SQL.
- Created Data mapping documents using Excel with legacy schema to new database schema.
- Created ETL logging process to identify failed ETL process.
- Created SSIS packages to load data from XML files to T-SQL tables using stored procedure.
- Wrote .NET utility to move .csv and xml file from shared drive to Amazon S3 bucket.
- Created data pipeline package to move data from amazon s3 bucket to MYSQL database and executed MySQL stored procedure using events to load data into tables.
- Created testing document to test entire ETL work flow.
- Applied business logic to create New Staging Databases on SQL Server 2008 R2 for new subject areas.
- Used different flow controls such as data flow task, sequence container, execute SQL task, expression, variables and script task.
- Worked with package configuration to migrate SSIS package from one environment to another.
- Used Jira and Agile methodology for project execution.
- Worked on code review and updated code in Win CVS.
E nvironment: SQL Server 2008R2, MY SQL Work Bench 6.3, .Net, SSIS, Amazon Data pipeline, Bit bucket, Bit bucket Confluence, Git Tool, Maven Command, Win CVS, Fare box, Jira, Agile Methodology
Confidential, Louisville, KY
Senior SQL Server Developer/SSIS
Responsibilities:
- Interacted with users, team lead, and technical manager to fully understand the requirements of the system.
- Created stored procedures, used complex queries involving join and union of multiple tables.
- Developed ETL jobs to load information into data warehouse from different relational databases and flat files.
- Implemented complex logging in SSIS packages.
- Performed Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
- Used execute SQL, Data Flow, Import Export controls extensively in SSIS.
- Performed multi file imports, package configuration, debugging tasks in SSIS.
- Installed packages on multiple servers in SSIS and scheduling package execution in SSIS.
- Worked on SSIS for data manipulation and data extraction, ETL Load.
Environment: SQL Server 2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Excel, XML, .NET
Confidential, Alpharetta GA
SQL Developer/SSIS/SSRS
Responsibilities:
- Analyzed, designed, and gathered business requirements.
- Created views and worked on slow running SQL and stored procedures to improve performances.
- Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
- Created tables, clustered, and non-clustered indexes and constraint.
- Generated and deployed ETL process in two step load data from file to staging, from staging to target database.
- Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
- Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
- Worked as Team lead on requirement gathering, coding, code review and updated code in Win CVS.
- Created Unit test and project workflow documents.
Environment: SQL Server 2012/2008R2, SQL Server Integration services, T-SQL, Red Gate, SSIS, Win CVS, Win Merge, Window 7
Confidential
Developer/SSRS
Responsibilities:
- Designed five approaches to integrate SSRS reports with 3C application.
- Analyzed, designed, and gathered requirements and created RUD.
- Created, designed and deployed reports on Confidential staging environment.
- Created views and worked on slow running SQL to improve performance.
- Generated stored procedures, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
- Created drill down, drill through, column hiding, row and column sorting reports.
- Developed various types of reports like drill down, drill through and parameterized reports using SQL Server Reporting Services 2008 R2.
- Interacted with the client, manager and BI COE to design workflow, project updates and suggestion.
- Created stored procedure and views to view data in reports.
Environment: SQL Server 2008 R2, SSRS, T-SQL Queries, MS Office 7, Java, .Net, Window 7