PROFESSIONAL SUMMARY:

• Over 9+ years of experience in working with Business Intelligence and Data Warehousing applications using the Microsoft Technologies such as SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS) ,and SQL Server Analysis Services (SSAS).
• Extensive experience in constructing Design Patterns, Database Design, Stored procedures, Triggers, Tables, User Defined Functions, Views, Indexes, Relational database models, and Data Integrity.
• Designed SSIS Packages to extract data from various data sources such as database, Excel spreadsheet, flat files and XML files into SQL Server 2008 for Data Storage, Analysis and Reporting.
• Expertise in database tools like SQL Server Management Studio (SSMS), and SQL Server Business Intelligence Studio (BIDS).
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation, and Testing with proficiency in Designing and Documentation of SQL Server Strategies and plans.
• Experience in configuration of report server and report manager scheduling, generating on - demand and scheduled reports for business analysis or management decision, giving permissions to different level of users in SSRS .
• Experience in multiple Relational Database Management systems (RDBMS).
• Experience in Software Configuration Management (Daily Build, Release and Testing methodology) using Team Foundation Server (TFS).
• Actively involved in Daily Scrum, Agile environment with Scrum Masters and Project Head Management.
• Extensively worked on Delaware Life Data conversion project to take it live.
• Worked with different levels of developers, administrators and analysts.
• Experienced in Load Testing, Code review and implemented automated unit testing with Visual Studio of various versions.
• Hands-on experience in SQL Server, C#, ASP.NET MVC, ASP.NET, ADO.NET, XML Web Services, Oracle, Python, Apache/Hbase, Cassandra and MongoDB. Experience in Data Models for ArcSDE for PostgreSQL
• Involved in Cube designing in Business Intelligence Development Studio using SSAS.
• Created Perspective views to allow users to quickly analyze large amounts of data and show the relationship between two measures.
• Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Experience in implementing error handling, exception management, tracing and logging features.
• Experience on NoSQL Databases such as Hadoop/base, Cassandra, MongoDB, and PostgreSQL on different platforms (AWS) and for moving and maintaining large volumes of data.
• Involved in Performance Tuning of Data Warehouses including the creation of materialized views, bitmap indexes and partitions.
• Strong analytical ability coupled with excellent written and verbal communication skills.
• Highly motivated, committed and a team player with capability to work independently, strong analytical ability coupled with excellent written and verbal communication skills. Able to work smoothly even under pressure to meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

TECHNICAL SKILLS SET:

SQL Server Tools: SQL Server Management Studio (2014, 2012, 2008, 2005), SQL Server Business Intelligence Development Studio, Visual Studio (2013, 2012, 2009, 2008)

Tools: SSIS, SSRS, Data Transformation Services (DTS), SSAS, Crystal Reports.

Databases : SQL SERVER, Oracle, Apache hive, Hadoop/base, Apache Cassandra, MongoDB, PostgreSQL and MYSQL

Big Data systems : Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Scala, Pig, Sqoop, and Cassandra.

Languages: T-SQL, PL/SQL, MYSQL, .Net, C#, Java, Python, Java Script, Bootstrap, JQuery, UNIX, HTML and CSS.

Development skills: T-SQL, SSIS/ SSRS/ SSAS, PL/SQL

Operating Systems: Windows 7, 8, 10, Windows 2008, 2003, XP, LINUX.

Technologies: SQL, .NET, C#, MySQL, ASP.NET, and Oracle.

PROFESSIONAL EXPERIENCE:

State of Ohio, Columbus

Data Conversion Specialist

Confidential

Responsibilities:

• Extracting data from SQL server from CAVU e-licensing legacy database systems into Cloud systems.
• In charge of building and architecting a process to load all the licenses of different boards into Sales force and AWS system. Create detailed mapping between legacy and new system data elements. Provide post-conversion support to the boards.
• Develop standardized procedures and functions for common conversion routines to increase data load efficiency.
• Contact customers to verify business rules and/or clarify data analysis.
• Perform data verification and identify that the data has been migrated correctly. Develop and modify T-SQL/PL-SQL queries.
• Ensure the documents and scripts are properly loaded in the TFS (team foundation Server).
• Using SSIS package to load and monitor the transactions of the renewals of licenses.
• Creating SSIS packages to recover and correct duplicate licenses.
• Create SSRS reports / adhoc reports depending on the requests posted by the analysts and team members.
• Verify the data integration between the Sales force and AWS system and the CAVU Website legacy systems (built using ASP.NET) systems.
• Manage the Production support on-calls after every release/patch of the data into Sales force from the SQL/ Oracle database systems.
• Was second-in-charge in handling the data functional team and data load team that consisted several developers, business analysts and solution engineers.
• Involved in giving bi-weekly updates in the fast paced Agile/Scrum environment. Updates were maintained in the Team Foundation Server (TFS)/ Visual Studio 2012/2015.
• Recycling the VB.net codes and transforming the logic into C# codes for using Microsoft Access in Child Support systems In order to retrieve the data for conversion into the Sales force system.
• Involved in keeping a track of online renewal transactions (OLR) such as CBOSS for medical/pharmacy/veterinary/nursing/dental/athletic boards.
• Separating the Medicaid shell record licenses from the winner record licenses.
• Installation and configuration of MongoDB in Windows platform. Configuring data replication in QA.
• Involved in setting up Hadoop clusters using Cloudera CDH3 and CDH4 on Linux.
• Involved in working on HBase Shell, CQL, HBase API and Cassandra Hector API.
• Selection, inserting large amounts of data. Performing Security measures, backups and restore backups
• Data migration from SQL and Oracle to Cassandra on AWS Platform.

Environment: MS SQL Server 12/14, SSRS (SQL Server Reporting Service) 2008 R2, Cassandra, AWS, Mongo DB, SSIS (SQL Server Integration Services), Visual Studio (2008, 2009, 2012, 2013, 2015), Apache Hive, Apache Cassandra, SQL Server Management Studio, MS Excel, Windows 7, Windows 8, Professional, TFS, Sales force, APEX, ASP.NET, Mule Soft, Oracle 11g, SharePoint 2010.                                     

Confidential

SQL Server Developer\SQL Database Administrator

Responsibilities:

• Played a prominent role as SQL Developer\SQL Database Administrator\Business Analyst for tracks involved in a Life Insurance Annuity/ Fixed Product for taking one of the big client project live, that helped in taking the company’s share to a higher level, thus leading to more product launches and inviting more clients.
• Worked in a major Conversion involving Data Conversion from one Database to another.
• Played an important role as a SQL Database Administrator in handling production databases for disaster recovery using availability groups concept.
• Involved in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database for CORE Team.
• Worked with Assisting and analyzing the UNIX scripting with Oracle DBA and Solaris Administrator for improving the Life CAD cycle.
• Created SSIS packages to meet the requirements of different work flows involved in the FAST application. Designed and developed SSIS packages, designed stored procedures, configuration files, tables, views, and functions. Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Created and automated SSRS reports in Report Builder 3.0 and Visual Studio 2012.
• Involved in sending Adhoc Reports to Operations, Suspense, Commissions team, Business Analysts, Programmer Analysts etc.
• Actively involved in Scrum, Agile environment through TFS and WebEx with various teams.
• Involved in Reconciliation Process in FAST\CORE (Downstream) track by creating tables, views, procedures at Source, Target and ETL Server level and populates results in final table to find out the mismatch columns between source and target values.
• Involved in calling several sql files and batch files using Windows PowerShell with DevOPS Team to fix new release obtain by FAST(New Jersey) to upgrade the Databases. Worked on installation of PostgreSQL with the team of Senior SQL DBA’s.
• Involved in Logical and Physical designing and implementing database design applications with FAST (NJ) for project on basis of client/user requirements.
• Extensively involved in Batch file Prepp process to match the collation in different databases.
• Extensive usage of Visual Studio 2010/2012/2013 for creating and deploying SSIS projects/ packages to integration catalogs, building .rdl reports for SSRS and managing the agile environment with different departments and teams through Team Foundation Server.
• Involved in using Toad for Oracle (11g /12.0g) for verifying and fixing the bugs involved in the ETL flow from FAST to CORE team.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table. Strong SSRS development skills, experience including Tablix, Matrix, chart, and graphic score card reports, and sub-reports.
• Experienced in planning and implementing MS SQL Server Security and database permissions.
• Designed and analyzed the SQL Server database and installed service packs for SQL servers, with Sys Admins and involved in gathering the user requirements.
• Created new tables, stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Designed and developed user interface using C#, jQuery, JavaScript, HTML and CSS on Visual Studio 2012/2013.
• Migrated data from SQL server to excel files for reporting the data
• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Worked with developers, SQL and ORACLE DBA, and systems support personnel in elevating and automating successful code to production. Involved in commissioning and decommissioning servers, update the server with system administrator. Performed full, transactional, and differential backup.
• Involved in disaster recovery working on failover clusters for Production Database.
• Involved with MYSQL prompt with interfaces team in order to upgrade their database from 2.0 to 3.0.
• Involved in Third party tools for Sales Force for data flow using SSIS Adapters COZYROC.
• Calling the SSIS Package for conversion from one sales force server into the SQL database.
• Extensively involved in updating data in Production environment.
• Adding and creating deleting groups using Active Directory in conjunction with system security.
• Developing availability groups for production. Involved in creating tickets using Remedy and JIRA.
• Was in Production Support to fix issues in nightly cycles that functioned using UC4Automics.
• Handled Production and QA jobs for the owned projects in the job step cycle.
• Provided on-call support to production system to resolve any issues.
• Managing Off-Shore team from India to check on the nightly cycle jobs run by UC4Automics.
• Involved in designing web UI for QA refresh using ASP.NET.

Environment: MS SQL Server 2005/08/12/14 , SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Visual Studio (2008, 2009, 2012, 2013, 2015), SQL Server Management Studio, MS Excel, Windows 7, Windows 8, Windows XP Professional, TFS.                                     

Confidential 

MS SQL Server Developer

Responsibilities:

• Involved in designing and implementing database applications using MS SQL Server 2008/2012 and Business Intelligence (BI) tools to support transactions and business decision-making.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Designed SSIS packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations (For loop, Data flow, Data mining, FTP, XML tasks, bulk insert, etc.) using SSIS.
• Migrated DTS packages to SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Deploying SSIS packages from various sources like bids, Management Studio, file systems etc.
• Worked in sending the transactions to the CTL Web services using SSIS packages.
• Developed stored procedures and used SSIS to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.   
• Data Warehousing Using Data Transformation Services Package (DTS).
• Experience in Solaris UNIX for server spatial adjustments and providing access to users.
• Performed data conversions from flat files into a normalized database structure.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Played a major role in getting the Data conversion part in taking data from one data type to another.
• Responsible for creating reports based on the requirements using SSRS.
• Experience in creating reports using SSRS and worked on OLAP/OLTP environment.
• Deployed the generated reports on to the server.
• Coordinated with the front-end developer to put in the business rules. Created procedure to check some of the rules at the backend at the time of entering data.
• Advanced extensible reporting skills, developed SQL Server reports using SSRS 2008
• Used Subscriptions and Snapshots to set up Push based Report Delivery.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Involved in developing web pages using ASP.NET  server controls, C++ and Javascript.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Designed and implemented SQL Server database objects (stored procedures, functions, views and complex T-SQL/queries) to support data integration (SSIS), reporting and various business processes.
• Implemented best practices to maintain optimal performance and optimized SQL queries for maximum efficiency.
• Worked with Remedy to issue tickets for fixing bugs.
• Followed Agile/Scrum Development Methodology with Bi-weekly Scrum for Project Development.

Environment: MS SQL Server 2005/08/12 (Query Analyzer, SQL Profiler), SSRS (SQL Server Reporting Service), SSIS (SQL Server Integration Services), Business Intelligent Studio, SQL Server Management Studio, ASP, Crystal Report, Enterprise Manager, MS Excel, Windows XP Professional, Team Foundation Server TFS.                                     

Confidential

SSIS/SSRS Developer

Responsibilities:

• Performed database management and address internal database configurations (tables, reports) and configurations between systems.
• Involved in Data Scrubbing in order to hide clients and customers’ personal information.
• Involved in creating SSIS packages, building, deploying and executing the packages in 3 environments (Development, QA and Production).
• Primary source of contact for any Package troubleshooting and reporting needs for Confidential IT department and other internal users.
• Worked in collaboration with data scientists at Monsanto (St Louis) with various NoSQL databases.
• Support the data warehousing MDM project to facilitate the merger process of regional airlines.
• Built reports in SSRS for errors generated by SSIS Packages.
• Responsible for gathering the requirements from the internal users of the Air Wisconsin team to meet their reporting needs and subscribe them with the appropriate authority.
• Developed database objects providing ad-hoc SQL scripts, stored procedures, Functions, and Triggers using T-SQL.
• Worked in Confluence to document the troubleshooting of jobs, packages, stored procedures
• Used SQL Server 2008 Integration Services (SSIS) to extracted data from flat file, and Excel spreadsheet to transform data and load the result into operational data store (ODS).
• Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical and free form reports from multiple data sources (relational and multidimensional) using SSRS.
• Created reports using SSRS 2008 and deployed them in the production server.
• Updates and inserts of records into data warehouse dimension tables using SCD type I, and type II in SSIS.
• Involved in Trigger development in database in order to prevent the users from updating the database through User Interface UI.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation, integration and testing, deployment and maintenance.
• Worked with various tasks of SSIS like Transform Data Task, Execute SQL Task, and Active Script Task etc.
• Worked with JIRA by Atlassian to carry the weekly tasks on moving the changes to Production Databases.
• Conduct code walkthroughs and review peer code and documentation.
• Proficient in Performance Tuning, Query Optimization and running Database.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Written stored procedures and triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Involved in creating web page from which SSIS package can be launched.
• Performed migration and data transformation from existing database to the new implemented database structure using SSIS.
• Scheduling Jobs, SSIS packages and Alerting using SQL Server Agent.
• Scheduling SSIS packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS wizard
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Responsible for deploying reports to Report Manager and Troubleshooting for any errors during the execution. Deploy/Design cubes in SSAS environment using Snowflake/ and Star Schema Designs for Data warehouse purposes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Worked with MYSQL prompt for a brief period and was involved in designing databases with proper enforcement of relational constraints

Environment: SQL Server Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), XML, VB.NET, MS PowerPoint, MS Project & Windows Server, Visual Basic, Windows XP, Microsoft Office, Microsoft Visual Studio 2008/05, Microsoft Access 2007, T-SQL,MYSQL.