SUMMARY

• Over TWELVE years of solid professional experience in Business Intelligence and development of applications using SQL Server, Integration Services (SSIS), Analysis Services(SSAS), Reporting Services (SSRS) and Power BI
• Expert in designing and handling Tabular, Sub Reports and Drill Down, Crosstab reports, Charts, Graphs using SSRS, Power BI, Tableau
• Extensive hands on development experience in data modeling, database architecture, building indices, developing stored procedures, monitoring, performance tuning, and trouble shooting.
• Experience in designing, enhancing, maintaining and supporting a variety of reports and ETL warehouses
• Extensive release management experience wif data warehouse applications and data mart design, wif emphasis on DDL and DML releases
• Expert in utilizing ETL tools including SQL Server Integration Services (SSIS), Pentaho Data Integration and ETL package design.
• Proficient in designing report layout, sorting the data, defining subtotals for the reports using SSRS
• Very good experience implementing robust solutions wif the .net framework languages such as VB and C#
• Excellent understanding of full Software Development Life Cycle (SDLC) and solid experience in AGILE methodologies such as SCRUM
• 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, SQL Server, DB2, MS Access, PostgreSQL, MySQL

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, Microsoft Office Suite (Word, Access, PowerPoint, Outlook), Microsoft Project, Erwin, Team Foundation Server, SharePoint, Visual Studio, TOAD, JIRA, SCRUM

ETL: SSIS, Pentaho Data Integration (PDI)

Reporting/Analytics: Tableau, Power BI, BIRT, SSRS, SSAS, Cognos, Pentaho Reports Designer (PRD), Jreports

Operating Systems: Microsoft Windows Family, Linux Ubuntu, UNIX

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior Business Intelligence Developer

Responsibilities:

• Created comprehensive conceptual, logical and physical data models from scratch for healthcare practitioners application and reports using Erwin
• Developed automated complex data transformations using SSIS 2014 in order to extract data from SQL Server source, transform the data and load it into target Oracle reporting database schema.
• Created robust T-SQL procedures, triggers, functions and did performance tuning on all the T-SQL queries by analyzing the estimated and actual execution plans and adding covering indexes
• Actively participated in daily standup SCRUM meetings, sprint planning, logging tasks in JIRA, sprint retro and sprint grooming sessions.
• Worked wif IT and business partners effectively and translated business specifications into cohesive report design and implementation.
• Created reports such as Examinee Performance, Examinee Certificates, Roster reports, Norm table and Group Performance reports dat convey meaningful information to the business using Tableau 10.

Confidential, NY

Senior Tableau Developer

Responsibilities:

• Made massive improvements in the speed of loading of all the Impact Meme Tableau dashboards and cut down the loading time from more TEMPthan 10-15 minutes to wifin 3 minutes for the 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 and adding different types of indexes.
• Developed an automated ETL process using SSIS 2016 dat populates the Impact Meme tables wif the incremental data load from SQL Server 2016 India machine and syncs them wif US Live. dis package TEMPhas tremendously improved the speed of data loading and cut down the data loading time from more TEMPthan 12 hours in some cases to just about a hour.
• Created UNIX shell scripts dat add all the abstracts to the Sphinx server as well as tag the abstracts properly wif each product.
• Created an automated ETL package utilizing SSIS 2016 dat detects all the possible combinations of data quality issues for Impact Meme and automatically sends the data quality report to the India team for cleanup.
• Developed a completely automated ETL process using SSIS 2016 for RML tracker dashboard dat grabs only the incremental data load from the relevant Profile Meme database and populates the underlying tables utilized in the tracker dashboards. Did a detailed analysis of the RML data and created queries dat fetch the most up to date and accurate data. Made massive improvements in the speed of tracker dashboard by means of tuning the underlying queries, re-arranging the tableau elements and adding appropriate indexes.
• Developed a completely automated process using SSIS 2016 dat 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. The ETL package deposits these dump files in the client SFTP folder and automatically sends the notification once the transfer is complete. their are also data validation checks being implemented in the package which prevents bad data from being sent to the clients thus ensuring the highest data quality.
• Performed a complete database migration from Oracle 12 C to SQL Server 2016 for Impact Meme and RML Tracker products. Effectively migrated all the tables, views, stored procedures, functions, partitions, indexes wifin a very short span of 4 weeks.
• Involved in the analysis, design and development of a new data warehouse as well as data mart and created powerful cubes using SSAS dat enabled business to make critical decisions using the data

Senior Reports Developer

Responsibilities:

• Created comprehensive conceptual, logical and physical data models for healthcare data for the State of Pennsylvania using Erwin
• Developed normalized database tables along wif the keys, constraints and relationships between these tables
• Utilized SSIS 2014 to perform thorough checks on the incoming files and load only clean data files to the database tables
• Performed a comprehensive optimization of all the database queries and used numerous tasks in SSIS such as for each, script task, data flow and execute SQL tasks and dis brought down the loading time from over 16 hours to just 5 minutes.
• Completely automated the SSIS packages on the ETL server so dat they run exactly at specified schedules and load the incoming files automatically.
• Utilized SSRS 2014 reporting tool effectively for creating various reports such as simple, crosstab, sub reports, drill down etc. formats such as in PDF, Excel, and CSV.

Confidential, TX

Senior SSIS/SSRS Developer

Responsibilities:

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

Confidential, TX

Data Reporting Analyst

Responsibilities:

• Interacted wif clients on a regular basis to discuss reporting and business requirements for each project
• Developed detailed project management plans in Microsoft Project for each event dat described the tasks, timelines and interdependencies between the various tasks in the report development life cycle
• Provided demonstrations and tutorials of the event management portal to clients
• Created Google widgets/charts using Google Analytics on the event management portal dat showed real time attendee metrics for each event
• Developed robust views, functions and stored procedures using SQL dat resulted in faster data retrieval from the database
• Created daily reports, as well as executive summaries using Tableau 8, dat consisted of key event metrics so dat clients can use the data to plan for future events
• Created additional self-serve Tableau 8 reports examining session survey response rates, session attendance, survey comments and session attendance chart by demographics for clients
• Produced dashboards detailing portal/mobile usage, session survey analysis and the expo sessions activity using Tableau 8.0

Confidential, MN

Business Intelligence Analyst

Responsibilities:

• Created a 3 NF normalized data model using Visio 2007 for the mortgage data
• Acted as a point of contact between the technology and bankruptcy teams to ensure effective and accurate delivery of all bankruptcy reports.
• Developed and optimized T-SQL stored procedures, functions, triggers dat captured all the exceptions in the bankruptcy procedure data.
• Designed SSIS packages for the import/export of data between SQL Server and various data sources such as Access, Excel, text files
• Created complex T-SQL stored procedures for generating a series of bankruptcy reports and also data extracts for usage by the bankruptcy team.
• Encapsulated the stored procedures for the bankruptcy reports and data extracts in SQL Server Agent jobs. Monitored all the nightly jobs on a daily basis by setting up email notifications, and fixed all the broken jobs.
• 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.
• Developed robust master schema and forms for the Fees data website using C# Winforms
• Expedited the fees data conversion process by means of developing an effective Excel VBA module dat copies all the relevant field values for fees data. Also developed an Access VBA module dat copies the cleaned up corporate advances data from the database as a new tab in the fees data source files corresponding to each account number

Confidential, IL

Business Intelligence Analyst

Responsibilities:

• Contributed greatly to the development of Request for Proposal (RFP) document for a new data warehouse implementation project wif the client
• Created a detailed list of business requirements gathering questions and discussed these questions wif the client and managers in great detail in order to prepare the business requirements documentation
• Developed a comprehensive high level business requirements documentation by discussing the business requirements thoroughly wif the client
• Developed a robust MDM functional requirements documentation template for in scope business functions for all the reports, inclusive of key information including report format, frequency, data sources/systems, and business users
• Learnt rapidly about the business processes involved in R&D Business Operations and utilized the Cognos tool in order to develop extremely effective end user reports dat provided high value to the client.
• Assisted the managers in the 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 the 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 the most relevant data fields in the data warehouse package, discovered the missing fields and reported them. Also recreated the entire report in Cognos wif the fields which were found.
• Validated and inspected each developed report thoroughly and ensured dat summarized and detailed data agree exactly to the desired output. Worked in conjunction wif the managers and an independent contractor and made sure dat the data issues in the reports were being resolved
• Prepared a knowledge transfer power point presentation for the purpose of halping the China offshore resources get up to speed quickly in the project and hence ensured a seamless transition of knowledge

Confidential, CT

SSIS/SSAS Developer

Responsibilities:

• Interacted wif the customer and collected extremely detailed business requirements and created a robust business requirements documentation
• Responsible for the User Acceptance Testing(UAT) of a Java based staff scheduling application for the 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 dat these defects were resolved
• Collaborated wif the 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 dat the latest releases of the application were tested thoroughly for quality before the deadline by means of effective organization and time management
• Created comprehensive system design documentation from scratch for the development of a robust electronic expense information system.
• Worked independently and developed highly effective flowcharts, workflow process diagrams, user screens, modules and reports for the 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 the 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 the application development team.
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Used DBCC commands to check physical and logical consistency of the 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 the performance of the SQL server queries using query plan, covering index, indexed views and by rebuilding and reorganizing the indexes.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used most of the 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 involvin