SUMMARY:

Having over 7+years of experience working as a SQL DEVLOPER, DATA ANALYST/Modeler

PROFESSIONAL EXPERIENCE:

Sr. Data Analyst/ Modeler

Confidential, Chicago, IL

Responsibilities:

• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Work collaboratively with data quality analysts, data stewards, and data governance team to resolve data quality issues
• Influence stakeholders to make product improvements that yield business value by effectively making compelling cases through story - telling, visualizations, and other influencing tools
• Worked on creating filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created data models in Splunk using pivot tables by analyzing vast amount of data and extracting key information to suit various business requirements.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Involved in data load/ export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/ Mainframes environments.
• Implemented data refreshes on Tableau Server for biweekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Maintained of large data sets, combining data from various sources by Excel, SAS Grid, Enterprise, Access and SQL queries.
• Designed and developed of ETL processes using Informatica ETL tool for dimension and fact file creation.
• Developed and automated solutions for a new billing and membership Enterprise data Warehouse including ETL routines, tables, maps, materialized views, and stored procedures incorporating Informatica and Oracle PL/SQL toolsets.
• Involved in data profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve quality of data and help business to understand the converted data better to come up with accurate business rules.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Documented, clarified and communicated requests for change requests with the requestor and coordinate with the development and testing team.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Involved in reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Coordinated with DBAs and generated SQL codes from data models. Generate reports for better communication between business teams

Data Analyst

Confidential, Herndon, VA

Responsibilities:

• Identified sources and performed data profiling on the identified sources
• Prepared specification documents (BRD / FRD), based on business rules given by Business.
• Prepared Business Process and Data Process Models using MS Visio.
• Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle
• Involved in data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
• Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
• Knowledge in developing SAS Programs using SAS/Base, SAS/macro and SAS/SQL.
• Involved in Installing Firmware Upgrades, kernel patches, systems configuration, performance tuning on UNIX systems.
• Involved in troubleshooting of UNIX technical problems received through e - mail and Clarify Ticketing Tool, Backup solutions according to the SOP & SLA. Generating reports, Preparing Quality Documentations & uploading to VSS tool
• Validated data in the report against the business data by running the SQL queries against the Teradata and Oracle.
• Researched and Developed Python scripts to reduce the generation of mapping applications
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Experience in creating the reports basing on the requirements using SSRS.
• Created Parameterized, Cascaded, Drill-down, and Drill-through reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Participated in daily Scrum meetings to review the status of sprint backlogs and sprint review meetings to discuss the accomplishments and issues faced.
• Worked on metadata clean-up and processing at regular intervals for better quality of data.
• Extract, summarize and compile data for required external reporting, Including Weekly Metadata Reports for the Data Integrity.

Environment: Teradata15.10, PL/SQL, UNIX, MS SQL Server 2012, SSIS & SSRS, MS Office, SCRUM, Microsoft Visio, Erwin Tool, Tableau.

SQL Server BI Developer

Confidential, Roanoke, VA

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Designed the packages to extract data from SQL DB, flat files and loaded into Oracle database.
• Involved in re - design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS.
• Performed data conversions from flat files into a normalized database structure.
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Environment: SQL Server 2008 Enterprise Edition, SQL Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, .NET Framework, C#, ASP.NET, CSS, T-SQL, VisualStudio.NET IDE, XML, MS Excel, MS Access, Visual Studio 2008, MongoDB 2.6/3.2.

Data Analyst

Confidential, Sandy Springs, GA

Responsibilities:

• Extracted, compiled and tracked data, and analyzed data to generate reports.
• Worked with other team members to complete special projects and achieve project deadlines.
• Developed optimized data collection and qualifying procedures.
• Leveraged analytical tools to develop efficient system operations.
• Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Used advanced Excel functions to generate spreadsheets and pivot tables.