SUMMARY

• Accomplished software engineer with 7+ years of experience through all software development phases from requirements definition, analysis to design, implementation, testing, maintenance and support. Leverages passion, self - motivation, and strong creative problem-solving skills to develop innovative solutions.
• Expert in installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008 in windows environment, BI components (DTS/SSIS, SSRS).
• Strong experience in SQL Server 2008R2 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Expertise in database design, development for OLTP (batch processing, online processing), OLAP, ODS, ETL data warehousing, data mining and data modeling.
• Expertise in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using import export wizard, DTS, SSIS, and bulk insert utilities.
• Experience in migrating DTS packages to SSIS, migrating databases from SQL 2000 to SQL 2005, and troubleshoot migration issues, importing and exporting packages to SQL Server and file system.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in managing and automating control flow, data flow, events and logging programmatically by using Microsoft.NET framework for ETL by SSIS packages.
• Experience in providing logging, error handling by using event handler in SSIS packages, performance tuning in SSIS packages by using row transformations, block and unblock.
• Experience in writing C# script for merge the file in command prompt.
• Experience in developing parameterized reports, linked reports, sub reports, create complex reports (ex: drill down reports using different objects), drill through reports using SSRS.
• Experience in creating views, triggers, functions, batch scripts and stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Proficient in writing complex T-SQL (DDL, DML), using new features like CTE, ranking functions, top(n), pivot and building referential integrity constraints.
• Archived the tables and files from business and other teams periodically to increase database free space.

TECHNICAL SKILLS

RDBMS: SQL Server 2000/2005/2008/2012

Languages: SQL, T-SQL, C, VB.NET, C#

Web Technologies: XML, IIS

ETL Tools : DTS, SQL Server Integration Services (SSIS).

BI Tools: Business Intelligence Development Studio (BIDS),SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import /Export, SQL Server Management Studio.

Reporting Tools: SQL Server Reporting Services (SSRS).

Operating Systems: Windows NT/98/2000/windows 7/Vista, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Lawrence, KS

Research Informatics Analyst/ Research Database Admin

Responsibilities:

• Expertise in automating builds and deployment process using Bash, Python, and Shell scripts.
• Rapid provisioning and configuration management for RedHat using Chef on AWS platform.
• Work experience on Amazon Web Services (AWS) such as Amazon Elastic Compute Cloud (EC2), Amazon Relational Databases (RDS), Amazon Simple Storage Service (S3), AWS Identity and Access Management (IAM), etc.
• Created DB instances and configure database parameter and DB snapshots, log file configuration, point-in-time restores and backups on AWS.
• Migration of Data from Reports generated by various stakeholder into PostgreSQL Databases using PostgreSQL Export/Import and ETL Procedures.
• Manage the Space and Storage of the Databases through various Bash Scripts scheduled in the corn tab periodically in regular intervals.
• Analyze the PostgreSQL logs and generate the pgBadger report for database performance monitoring.
• Used Amazon RDS Multi-AZ for automatic failover and high availability at the database tier for production workloads.
• Develop performance tuning, backup/recovery, and scalability/capacity planning, in addition to SQL, PL/SQL, and UNIX shell scripting.
• Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On-Call support.
• Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing and configuring PostgreSQL servers and database restore using AWS CLI.
• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
• Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.
• Assist development team in the database design of appropriate table schema and indexing strategy for performance and scalability.
• Identifying and resolving incidents and address to user production server problems/defects and troubleshooting database issues.
• Identify SQL improvements and query tuning PL-SQL code with Amazon RDS performance Insight tools and EXPLAIN ANALYZE.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.
• Created different types of store procedure for the logging and auditing validation purposes.
• Ensure night corn jobs for backups, Re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability on production and development databases.
• Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.
• Proficiency in RDBMS concepts, SQL scripting and Athena and AWS Glue ETL Services.

Environment: Linux, Microsoft SQL Server 2014/2016, GitHub, SVN, PGAdmin, PostgreSQL, SQLite, Windows server 2010, Internet Information Server (IIS), MS Excel 2016, Java, and AWS RDS.

Confidential, Chicago, IL

SQL Server/ BI Developer

Responsibilities:

• Coordinated with front-end developers for implementing business logic.
• Designed and developed SQL ETL Process &SSIS Packages to extract data from several source systems.
• Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL statements for application
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Performed rebuilding of indexes at regular intervals to reduce page splits.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2005 Reporting Services
• Write Complex SQL Queries to generate Reports based on the business requirement
• Transfer data in secure way to project the member information and protect the HIPAA standards.
• Created Parameterized reports and Linked reports which navigates to other report.
• Experience to use Bug tracking tools like Jirra control the changes by using Emergency Change control.
• Experience in Health care data analysis for medical claim subrogation process according to diagnose codes & CPT codes and Procedure codes.
• Developed reports from the OLTP and OLAP databases using SQL Server Reporting Services.
• Proficiency in RDBMS concepts, SQL scripting.
• Scheduled reports for Daily, Weekly, Monthly reports for various categories and regions based on business needs using Reporting services (SSRS)
• Designed reports using SQL Server Reporting Services SSRS based on Data Warehouse which makes use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.

Environment: SQL Server 2005 Enterprise Edition, SSRS, SSIS, SSAS, Windows Enterprise Server 2003, Microsoft Visual studio, Microsoft office.

Confidential, Columbus OH

SQL Server & Integration Developer

Responsibilities:

• Gather information from the client and create FTP and SFTP connection for the secure file transfer system.
• Prepare and maintain proper document the user Id’s and password information for the new connection managers configurations in SSIS deployments.
• Extract the various types of the eligibility, claims, biometric and online registration file from the client in different format like fixed length and other type of delimiter flat files and Excel and CSV type files.
• Archive the files in Archive folder to maintain the complete historical Information and to track the file information & Notifications purpose.
• Create SSIS packages to load the information into database and clean the data validation errors and map to the correct columns.
• Create package variable and package connections in Integration server 2012 to minimize the development time and maintain the SSIS template packages for same process type of data load.
• Use the C# scripting to download files from the Secure FTP connection and check the pattern of the files exists in the location and send the notification.
• Build and deploy the packages into integration service catalog database and maintain proper logging formation for package validation error and execution errors and execution time.
• Find the matched and unmatched record and map to the unique id’s and maintain the unmatched record with zero unique id’s until find the proper matching unique id.
• Resolve the production level and priority tickets. Resolve the issues and finish the development within the time frame for SSRS reports.
• Understand the business requirement changes in the real time and maintain proper test cases as per the requirement changes.
• Maintain and schedule the jobs in hourly and daily and weekly bases depends on the timing frequency on the SSIS data loads.
• Develop the Adhoc report and percentage report and summarized information report for the group level.
• Build the subscription of repot and maintain the schedule for the secure email delivery.
• Provide the data only report for the client in dash board method in the various kinds of the report like parameter report and drilldown report.
• Create replication process to maintain the transactional database and historical data in sync.

Environment: Microsoft SQL Server 2012,SVN Tortoise, FileZilla, Melissa Data, Oracle 11g, Crystal reports, Dash Board Report, Teamcity.

Confidential

SQL Server Developer

Responsibilities:

• Built ETL design structure using SQL Server Integration Services by incorporating Extraction, Transformation, Load and Purge phases for the Enterprise Warehouse solution.
• Developed and implemented custom logging structure in Event Handlers for all the SSIS packages using SSIS system variable such as Package Name, Package Start Time, etc.
• Designed and implemented data imports from several Point of System servers with SQL Server source as well as CSV flat file sources to Production environment using SQL Server Integration Services.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Effectively utilized protection level property of SSIS packages for secure storage and transfer.
• Implemented Encrypt AllWithPassword and Server Storage protection level extensively during package development.
• Create script in C# for dynamically passing connection string parameters to SSIS packages in development, testing and production environments.
• Created parameterized reports for the Attorneys and clients.
• Formatted the report layout for the requirement of the end users.
• Deployed the developed reports and upgraded the system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and
• T-SQL, PL/SQL code and Ad-hoc SQL Queries to test and implement business rules.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Create a complex store procedure to generate the different format files as per the Client required format.

Environment: Microsoft SQL Server 2008 R2,VSS, Visual studio, SQL Developer, Oracle 11g, SQL Server Reporting services(SSRS),SQL Server Analysis Services(SSAS).

Confidential, Irving, TX

SQL Server Developer

Responsibilities:

• Gathered user requirements, analyzed and designed of software and database solutions.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups.
• Develop parameterized reports, caching reports, sub reports and Ad Hoc reports using SSRS.
• Implemented error handling and utilized event handlers for automated notifications using SSIS.
• Developed stored procedures, functions, views, triggers, and migrated data from different databases to SQL server.
• Defined granularity with in a measure group and drill through actions.
• Wrote the queries for the drill down reports, identified and added the report parameters by using SSRS.
• Worked on using C# script task for complex transformations like processing of multiple formatted files.
• Worked on creating simple reports using Report viewer control and ASP.NET with VB.NET and C#.
• Formatted the reports using the global variables and expressions in SSRS, deployed the generated reports on to the Reporting server.
• Created SSIS packages for transferring the data from different systems.
• Increased query performance by 20%, which is necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Transformed the complex business logic and calculations into coding.
• Gathered information about the system and assisted in the development of deliverables. Worked with the clients to gather system requirements.
• Established and created program evaluation and reviewing for the project lifecycle.
• Create and assign various security roles in Reporting Server like Browser role, Report Builder role, Publisher role and Content Manager Permissions.
• Developed stored procedures to maintain database integrity and information workflow.
• Implemented and maintain ETL processes & SSIS packages to consolidate data from other business units and departments (Excel, CSV, and Text).
• Design and develop a reporting schema and deploy into reporting server by using SSRS.
• Administered the MS SQL Server by creating roles, user logins, monitoring user accounts, granting user permissions to users and groups.

Environment: Microsoft SQL Server 2005/2008 R2 Enterprise edition, TFS, TAOD, Talend, SQL Developer, Oracle 11g, Windows server 2003, Internet Information Server (IIS), MS Excel 2007.