SUMMARY

• Over TWELVE years of solid professional experience in System Analysis and development of applications using SQL Server, DB2, Integration Services (SSIS), Reporting Services (SSRS) and Team Foundation Server(TFS)
• Solid experience in creating powerful charts, graphs and dashboards that convey meaningful data and insights using tools such as Tableau 8.0, BIRT and Google analytics
• Expertise in designing and optimizing teh various T - SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.
• Expert in interacting wif teh customer, collecting business requirements, preparing business requirements documentation, developing test cases/plans, project management and use case modeling.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Expert in utilizing ETL tools including Pentaho Data Integration, SQL Server Integration Services (SSIS) and ETL package design.
• Expert in designing and handling SQL Reports, Sub Reports and Drill down Reports and Crosstab reports
• Proficient in designing report layout, sorting teh data, defining subtotals for teh reports using SSRS 2008.
• Expertise in Microsoft Reporting Service (SSRS) wif Report Authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.
• Excellent understanding of full Software Development Life Cycle (SDLC)
• Worked in a plethora of industries like Financial Services, Health Care, Pharmaceuticals, Event Management, Insurance and Agriculture/Food & Nutrition
• Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema).
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.
• Excellent communication and analytical skills

TECHNICAL SKILLS

Databases: Oracle 9i/10g/12c, SQL Server 2014, DB2, MS Access 2010, PostgreSQL

Programming Languages: C / C#, SQL, PL/SQL, T-SQL, VBA, XSLT, XSD, HTML, CSS, Python, UNIX/Batch Scripting, Windows PowerShell.

Tools: /Methodologies: SQL Server Management Studio, SQL Server Profiler, Microsoft Office Suite 2007(Word, Access, PowerPoint, Outlook), Microsoft Project 2007, Microsoft Visio 2007,Team Foundation Server(TFS) 2013, SharePoint 2010,Visual Studio 2010, TOAD.

ETL: SSIS 2014, Pentaho Data Integration (PDI) 6.0, VEDIT, WinSCP.

Reporting: Tableau 9.0, BIRT, SSRS 2008, Cognos, Pentaho Reports Designer (PRD).

Operating Systems: Microsoft Windows Family, Linux Ubuntu, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior SSIS/SQL Server Lead

Responsibilities:

• Made massive improvements in teh speed of loading of all teh Impact Meme tableau dashboards and cut down teh loading time from more than 10-15 minutes to wifin 3 minutes for teh dashboards. dis massive speed optimization was done by using a combination of techniques such as rearranging views in tableau, utilizing highly tuned parametrized T-SQL queries, added different types of indexes.
• Developed an automated ETL process using SSIS 2014 that populates teh Impact Meme tables wif teh incremental data from SQL Server India machine and syncs them wif US Live. dis package has tremendously improved teh speed of data loading and cut down teh data loading time from more than 12 hours in some cases to just about an hour.
• Created an automated ETL package utilizing SSIS 2014 that detects all teh possible combinations of data quality issues for Impact Meme and automatically sends teh data quality report to teh India team for cleanup.
• Developed a completely automated ETL process using SSIS 2014 for RML tracker dashboard that grabs only teh incremental data from teh relevant Profile Meme database and populates teh underlying tables utilized in teh tracker dashboards. Did a detailed analysis of teh RML data and created queries that fetch teh most up to date and accurate data. Made massive improvements in teh speed of tracker dashboard by means of tuning teh underlying queries, re-arranging teh tableau elements and adding appropriate indexes.
• Developed a completely automated process using SSIS 2014 that generates delta data dumps for New as well as Updated KOL names along wif their pertinent information such as Presentations, Contact Information, Publications, Education, Clinical Trials, Treatment Guidelines, Roles customers. Teh ETL package deposits these dump files in teh client SFTP folder and automatically sends teh notification once teh transfer is complete. There are also data validation checks being implemented in teh package which prevents bad data from being sent to teh clients thus ensuring teh highest data quality.
• Performed a complete database migration from Oracle 12 C to SQL Server 2014 for Impact Meme and RML Tracker products. Effectively migrated all teh tables, views, stored procedures, functions, partitions, indexes wifin a very short span of 4 weeks.

Confidential, PA

Responsibilities:

• Created comprehensive conceptual, logical and physical data models for healthcare data for teh State of Pennsylvania using SQL Data Modeler
• Developed normalized database tables along wif teh keys, constraints and relationships between these tables
• Developed robust stored procedures, functions, triggers, indexes in SQL Server 2014 to do a lot of data manipulation and transformation tasks.
• Utilized SSIS 2014 to perform thorough checks on teh incoming files and load only clean data files to teh database tables
• Performed a comprehensive optimization of all teh database queries and used numerous tasks in SSIS such as for each, script task, data flow and execute SQL tasks and dis brought down teh loading time from over 16 hours to just 5 minutes.
• Completely automated teh SSIS packages on teh ETL server so that they run exactly at specified schedules and load teh incoming files automatically.

Confidential, NY

Senior SSIS Developer

Responsibilities:

• Responsible for teh daily Extract, Transform and Load(ETL) of teh EBCDIC data into teh appropriate target databases based on teh portfolio of teh incoming data files
• Improved accuracy and speed of teh entire ETL by developing automated Windows batch scripts that decrypt/unzip teh container files, perform operations on teh individual files and finally load them into teh target databases
• Analyzed files for loading issues and updated SQL load scripts to ensure proper loading.
• Update and send teh process log for teh client dashboard on a daily basis wif information about teh files that expected, received, loaded and reconciled for each day
• Developed end-to-end automation for data refreshes of account performance and application analysis of all bank portfolios using SSIS 2008. dis resulted in savings of at least 40 hours saved per week per portfolio and also completely eliminated errors in teh update process.
• Created an automated log system in SSIS to keep track of source tables, repository objects, records inserted/updated, portfolios and package run time on a daily basis and email teh process log summary to teh end users.

Confidential, TX

Senior SSIS/SSRS Developer

Responsibilities:

• Interacted wif teh customer and teh systems analysts for teh purpose of obtaining detailed and accurate business and functional reporting requirements
• Developed new reports and enhanced teh existing reports using SSRS 2008 tool based on teh requirements for teh Department of Agriculture as well as Food and Nutrition programs.
• Converted all teh developed SSRS reports into on-demand so as to enable customers to run teh reports from teh portal wif teh appropriate filters/parameters, thereby resulting in huge time savings
• Reviewed teh developed SSRS reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and teh functional purpose of these reports
• Extracted existing data using SSIS/SSRS to manipulate/calculate/format into reports, charts, graphs and dashboards.
• Utilized teh SSIS 2008 to automatically extract/ transform data from source databases for clients based on requested time intervals.

Confidential, TX

Data Reporting Analyst

Responsibilities:

• Interacted on a regular basis wif teh customers, collected detailed reporting requirements and created robust business requirements/reporting plans that consisted of all teh reports that were needed along wif teh timelines for each report
• Developed detailed project management plans in Microsoft Project 2007 that shows teh tasks, timelines and interdependencies between teh various tasks in teh report development life cycle for each event.
• Provided detailed demonstrations of teh event management portal to teh customers and also provided them wif an overview of teh reports to be delivered
• Worked on some additional tasks such as creating Google widgets/charts using Google Analytics on teh event management portal that showed near real - time and potent attendee metrics for each event
• Developed very robust views, functions and stored procedures using SQL that assisted in much faster data retrieval from teh database thereby saving a lot of time.
• Created Daily as well as Executive Event Metrics Summary reports that consisted of some of teh key data such as attendees seen/associated, first seen, top sessions attended, average duration for expo hall sessions hence providing a lot of value for teh customers
• Took a lot of initiative and created additional self- serve BIRT reports such as session survey response rates, session attendance, survey comments and session attendance chart by demographics and hung them on teh portal so that they could be accessed easily by teh customer
• Cleaned up teh raw registrations, sessions and associations data and loaded them into teh database properly using teh load tool in teh portal as well as through teh import tool in TOAD
• Produced slick looking and extremely useful dashboards such as portal/mobile usage, session survey analysis and teh expo sessions activity using Tableau 8.0
• Provided very detailed noledge transfer to teh new team members in teh reporting team and quickly got them up to speed.

Confidential, MN

Senior SQL Server/SSIS/SSRS Consultant

Responsibilities:

• Created a 3 NF normalized data model using Visio 2007 for teh mortgage data
• Acted as a point of contact between teh technology and bankruptcy teams and communicated effectively wif teh bankruptcy team members for gathering teh requirements for all teh bankruptcy related reports.
• Created complex T-SQL stored procedures in SQL Server 2008 for generating a series of bankruptcy reports and also data extracts for usage by teh bankruptcy team.
• Developed robust T-SQL stored procedures, functions, triggers that captured all teh exceptions in teh bankruptcy procedure data.
• Designed SSIS packages for teh import/export of data between SQL Server and various data sources such as Access, Excel, text files
• Encapsulated teh stored procedures for teh bankruptcy reports and data extracts in SQL Server Agent jobs.
• Monitored all teh nightly jobs on a daily basis by setting up email notifications and fixed all teh broken jobs.
• Developed robust SSIS packages for automating teh import/export of bankruptcy data/generation of bankruptcy exceptions, thereby improving teh overall efficiency of these processes and saving a lot of time.
• Utilized SSRS 2008 reporting tool effectively for creating various reports such as simple, crosstab, sub reports, drill down etc. formats such as in PDF, Excel, and CSV.
• Validated and inspected each SSRS Report thoroughly and ensured that summarized and detailed data agree exactly to teh desired output.
• Developed robust master schema and forms for teh Fees data using C # Win Forms
• Expedited teh fees data conversion process by means of developing an effective Excel VBA module that copies all teh relevant field values for fees data. Also developed an Access VBA module that copies teh cleaned up corporate advances data from teh database as a new tab in teh fees data source files corresponding to each account number

Confidential, IL

Business Intelligence Analyst

Responsibilities:

• Contributed greatly to teh development of Request for Proposal (RFP) document for a new data warehouse implementation project wif teh client
• Created a detailed list of business requirements gathering questions and discussed these questions wif teh client and managers in great detail in order to prepare teh business requirements documentation
• Developed a comprehensive high level business requirements documentation by discussing teh business requirements thoroughly wif teh client
• Developed a robust MDM functional requirements documentation template for in scope business functions for all teh reports, inclusive of key information including report format, frequency, data sources/systems, and business users
• Learnt rapidly about teh business processes involved in R&D Business Operations and utilized teh Cognos tool in order to develop extremely effective end user reports that provided high value to teh client.
• Assisted teh managers in teh project by means actively contributing to discussions and doing tasks such as deploying project MAP file, preparing weekly status reporting template and requirements gathering questions/documentation.
• Recreated some of teh complex excel reports already developed utilizing Cognos and demonstrated how dis technology could be used to develop reports much more efficiently and hence save substantial report development time.
• Compared a ninety field pillar type report against teh most relevant data fields in teh data warehouse package, discovered teh missing fields and reported them. Also recreated teh entire report in Cognos wif teh fields which were found.
• Validated and inspected each developed report thoroughly and ensured that summarized and detailed data agree exactly to teh desired output. Worked in conjunction wif teh managers and an independent contractor and made sure that teh data issues in teh reports were being resolved
• Prepared a noledge transfer power point presentation for teh purpose of halping teh China offshore resources get up to speed quickly in teh project and hence ensured a seamless transition of noledge

Confidential, CT

Business Systems Analyst

Responsibilities:

• Interacted wif teh customer and collected extremely detailed business requirements and created a robust business requirements documentation
• Responsible for teh User Acceptance Testing(UAT) of a Java based staff scheduling application for teh Healthcare Industry
• Created regular backups and restored MySQL and SQL Server client databases, logged issues in a bug tracking tool and communicated wif developers to make sure that these defects were resolved
• Collaborated wif teh QA team to prepare test cases and plans using established templates and guidelines in accordance wif in-house Quality Management Standards
• Conducted requirements feasibility analysis wif developers and developed design documents to conform wif customer requirements
• Ensured that teh latest releases of teh application were tested thoroughly for quality before teh deadline by means of effective organization and time management
• Created comprehensive system design documentation from scratch for teh development of a robust electronic expense information system.
• Worked independently and developed highly effective flowcharts, workflow process diagrams, user screens, modules and reports for teh electronic expense system.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Created SSIS Packages for both OLTP and OLAP database.
• Created and scheduled teh packages using SQL Server DTS packages.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Has designed, developed and implemented database security in SQL server 2008 successfully.
• Monitored and scheduled existing/new jobs on production environment.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination wif teh application development team.
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Used DBCC commands to check physical and logical consistency of teh databases and rebuild indexes.
• Extensively used Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa.
• Used SQL Server Reporting Services (SSRS) to generate Reports in various output formats.
• Created a report model on SSAS cubes
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Provided technical architecture and database engineering support to move databases from development to test and production for multiple applications.
• Developed and maintained Enterprise database management Architecture for SQL server 2008.
• Monitored MS SQL Server performance using performance monitor and profiler.
• Created login accounts and database user accounts and managed database security using groups and roles.
• Created Logical and physical Data models for SQL server 2008.
• Improved teh performance of teh SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing teh indexes.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used most of teh controls and features in SSIS /DTS for transforming data from different sources.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Used MS SQL Server reporting services (SSRS) to use daily report basis wif client-server application.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.