PROFESSIONAL SUMMARY:

• Over 8 years of diversified IT experience in data modelling, data analysis, database management, data integration and report development
• Experience in collecting, organizing and evaluating business data for developing the technical business requirements
• Proficient in analyzing and drafting Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)
• Expertise in creating ETL(Extract, Transform, Load) workflows using SSIS (SQL Server Integration Services), extracting and loading data from various sources to data mart/ data warehouse
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and SSIS Packages
• Proficient in developing reports using SSRS and creating visualizations using PowerBI and Tableau
• Thorough understanding and experience in OLTP and OLAP systems, relational database, ER Modeling, star schema, snowflake schema, normalization and de - normalization principles
• Experience in creating Tables, Views, cursors, stored procedures, functions and database triggers
• In-depth experience of Transact-SQL (DDL, DML), Designing & Normalization techniques on the DB tables
• Well versed in SQL tuning to deal with performance issues
• Strong experience in writing SQL code for data validation and reporting purpose
• Good working knowledge of Excel/ VBA, DAX on PowerPivot and Excel Pivot tables
• Good knowledge of software development life cycle, database design and RDBMS
• Exposure to Big Data like Vertica and Amazon Web Services (AWS)
• Familiarity with Waterfall and Agile/Scrum models

PROFESSIONAL EXPERIENCE:

MSBI Developer/ SSIS/ SSRS/ PowerBI Developer

Confidential, Burr Ridge, IL

Responsibilities:

• Studied the legacy systems and other data warehouses and created corresponding database schema in the target SQL server environment
• Created a high level design document which contains the specification details for the project
• Utilized Fuzzy look up transformation of SSIS to a great advantage in order to perform data cleansing tasks
• Developed detail and summary reports line, trend analysis reports and sub-reports according to business requirements using SSRS
• Edited/ created reports and custom visualizations using PowerBI

Environment: TSQL, SSIS, SSRS, SQL Server 2016, PowerBI

Data Analyst/ Data Modeler / SQL Server Developer

Confidential, GA

Responsibilities:

• Created ER Diagrams, Data Flow Diagrams, grouped and created tables, validated the data, identified PK/ FK for lookup tables
• Performed GAP Analysis of business rules, business and system process flows
• Identified, organized, and documented the changing requirements of a project
• Conducted and participated in JAD sessions with the project managers, business analysis team, finance and development teams to gather, analyze, and document the business requirements
• Prepared logical and physical data models by recognizing proper entity, attributes and implementing a relationship between them using ERwin
• Worked on data mapping process from source system to target system
• Generated statistical reports for quality checks and reporting for billing departments
• Coordinated with DBA on database build and table normalizations and de-normalizations
• Assisted Business Intelligence team in generating various interactive reports
• Applied data cleansing techniques to ensure consistency among data sets

Environment: TSQL, SSIS, Sql Server 2014, Visual Studio 2015, Erwin, PowerBI

ETL Developer/ SSIS Developer

Confidential, Atlanta, GA

Responsibilities:

• Data migration tasks were accomplished via SQL Server Integration Services (SSIS)
• Implemented configuration files to deploy the SSIS packages across all environments
• Designed, developed and deployed job scheduling reports and success/failure notifications in MS SQL Server environment using SSIS in Sql Server data Tools (SSDT)
• Used SSIS to develop jobs for (ETL) extracting, cleaning, transforming and loading data into data warehouse
• Created SSIS packages, Email alert for SSIS packages and scheduled it through Subscriptions
• Designed SSIS Packages to transfer data from flat files to SQL Server using SSDT
• Created SSIS packages for File Transfer from one location to the other using FTP task
• Wrote T-SQL statements for retrieval of data
• Extensively used SSIS transformations such as Lookup, Derived column and Data conversion
• Generated reports for the senior management for monitoring progress and facilitate the management on impact, issues and risks

Environment: TSQL, SSIS, SSDT, SSRS, Sql Server 2014

IT Analyst/ SQL Developer

Confidential, SFO, CA/ Chicago, IL

Responsibilities:

• Compiled and maintained spreadsheets detailing company and departmental budgets for over a 3-year period that included KPI (Key Performance Indicators) metrics, Gantt diagrams and Excel pivot tables/ charts
• Created an in-house database, with MS Access 2000, for storing, querying and creating reports about the contact information of different agencies
• Built, published and customized interactive reports and Tableau dashboards
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Built end to end reporting layer in Tableau Dashboard for analytical, operational, real- time and adhoc reporting environment
• Developed Tableau workbooks from multiple data sources using data blending, interactive views, trends and drill downs
• Worked with SQL queries including complex joins, nested queries, stored procedures and common table expressions (CTEs) for integration and management of data
• Used reporting tools like Tableau and Spreadsheets to assess program performance and customer behavior
• Lead cross-functional teams and coordinated on multiple projects
• Adapted agile scrum methodology

Environment: Excel 2013, Access 2013, TSQL, Tableau

Database Analyst

Confidential, IL

Responsibilities:

• Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
• Downloaded daily extracts from SFTP server and uploaded them into data warehouse after performing various data integrity checks
• Prepared data comparison sheet to compare record counts in tables against the expected counts
• Prepared and posted daily data services status report

Environment: EXCEL 2013, TSQL, SSIS

Data Analyst/ Business Systems Analyst

Confidential

Responsibilities:

• Developed custom, dynamic reports integrated with Interactive Intelligence System for the Center, using Crystal Reports
• Worked with Marketing, Sales and User Interaction Center (UIC) divisions to create a series of reports matching the requirements provided by these departments using Excel
• Instituted on-line reporting on the company’s intranet, which increased productivity rate of the UIC by 24% within 6 months
• Compiled and generated Excel spreadsheets capturing accurate data related to company’s active contracts and detailed information on loan and lease accounts originated
• Developed dashboards to project revenue on a monthly and quarterly basis by region, subsidiaries, financial services and operations using crystal reports
• Produced ad-hoc reports, to answer business questions that helped facilitate timely decision making in corporate banking

Environment: Crystal Reports, EXCEL 2002, MySQL

SQL/Reports Developer

Confidential

Responsibilities:

• Maintained data integrity and database structure including tables, views, and triggers
• Optimized sluggish performance in certain reports, by harnessing query optimization techniques such as creating an index, re-organizing existing indexes
• Built effective queries for high-performance reports and rendered them to PDF and Excel formats
• Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing T-SQL
• Conducted a detailed feasibility study of migrating from Crystal Reports into SSRS (SQL Server Reporting Services)
• Assessed online e-commerce information, data lifecycle sustainment and risk processes for entertainment channels

Environment: SQL Server 2000, SSRS, Crystal Reports, EXCEL 2002