SUMMARY

• Over 10+ years of experience as Teradata, MS SQL Server Database / ETL / Warehouse developer.
• Experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using MS SQL Server 2012/2008 /2005 and Teradata.
• Proficient in maintenance and optimization of Database using SQL server database engine profiler and SQL server tuning advisor.
• Experience in with SSAS, SSIS, SSRS, MS Excel & Tableau for various BI requirements.
• Experience in working with OLTP & OLAP environment that includes Production (24x7), QA and development databases.
• Experience in EXPRESS OLAP and Data Warehousing database architecture and star schema design.
• Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Data Transformation Services (DTS), Bulk Insert).
• Experience in designing drilldown, cascade reports, parameterized reports, sub reports and designing of Report model for Ad - hoc reports using Excel, SSRS, Tableau .
• Has experience in implementation of report execution setting, security settings, subscription setting for reports on reports server.
• Very good understanding of Data Warehouse concepts and Ralph Kimball’s data warehouse methodologies for the full life cycle of the Data warehouse.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in Dimensional Modeling, Kimball methodology, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables, and Operational Data Store (ODS).
• Experienced in design of logical and physical data modeling using Erwin/MS Visio data modeling tool.
• Proficient in implementing business logic and batch process in backend using Stored Proc and Functions.
• Working knowledge of Software Development life Cycle (SDLC) and N-tier Application Architecture
• Strong business acumen, strategic thinking, communication, interpersonal and presentation skills, adept Confidential creating, editing, and coordinating extensive communication networks.
• Strong work ethics, taking ownership of all duties and responsibilities and efficient time management skills. Group and individual based problem solving and decision making.

TECHNICAL SKILLS

Operating Systems: Windows 2003 / NT / XP/ Vista/ Windows 7/ Windows 10/ Windows Server 2010/2012

Languages: C, C++, C#, VB, SQL, T-SQL

Web Technologies: HTML, ASP.Net, WML, XML

Databases: MS SQL SERVER 2012/2008/2005 / 2000 , MS Access 2003, Teradata

Packages: MS Office 2013/2010/2007/2003 , MS Visio

BI tools: DTS, SSIS, SSAS, SSRS, Tableau, Excel, Qlik, Knime, ThoughtSpot

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts,, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Irving TX

Data Analyst/Sr BI Developer

Responsibilities:

• Designed and developed multiple Business Intelligence solutions for reporting and data analysis.
• Designed and developed Data Warehouse using Star and Snow flack schemas for OLAP cubes and reporting solutions.
• Designed and developed several OLAP cubes using SQL Server Analysis Services (SSAS).
• Designed and building ETL processes between homogeneous and heterogeneous systems using SQL Server Integration Services (SSIS) and Knime.
• Automate database processing and data loads using Stored Procedures, Triggers, functions and Bulk data load using ETL processing.
• Automate processing using Unix Shell Scripting.
• Proficient in develop and maintain SQL Server and Teradata database solutions.
• Built daily/weekly/monthly reports, dashboards and pinboards using Excel and Tableau.
• Collaborated extensively with Business Clients to gather requirements and built BI solution.
• Collaborated with Business Clients to deliver ad hoc requirements.

Technologies: SQL Server 2012, Teradata, SSIS/SSAS 2012, Visual Studio 2010, MS Office 2010/2013, Tableau, Qlik, Knime, ThoughtSpot

Confidential - Chicago, IL

Sr. Database Developer

Responsibilities:

• Responsible for Planning, Defining and Designing BI solution and data model based on business requirements and provided documentation.
• Collaborated with Project managers and client managers to deliver solutions and application within time frame with highest quality.
• Assisted Project managers in estimation and project plans for Database solutions
• Created and managed BI solutions using SSIS as ETL tool, SSRS Reporting tool and SSAS Analysis tool
• Created and managed SQL and BI solution in all three environments, Development, Test and Production
• Created and managed SSIS packages to transfer data from various systems.
• Created complex SSIS packages using proper control and data flow elements.
• Created packages in SSIS with error handling.
• Deployed packages on different servers by configuring it.
• Created and managed SQL Agent jobs to run SSIS packages.
• Created and managed SSRS Reports according to Client requirements.
• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS
• Well versed in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, SQL joins .

Technologies: SQL Server 2012, SQL Server 2008/2008 R2, SSRS/SSIS/SSAS 2008/2008 R2, Visual Studio 2005, MS Office 2007/2010

Confidential - Des Moines, IA

SQL Developer/ Report Developer

Responsibilities:

• Migrated mainframe reports to SSRS reports using SQL server 2008.
• Created SQL solution to enhance reports and populating data for Reports
• Involved in gathering requirements for reports from Stack holders and end clients.
• Created a number of reports with dynamic parameters accommodating the changing reporting needs of various business users. Also proficient in working with static parameters .
• Extensively worked with MS SQL Server Reporting Services ( SSRS ) 2005 and 2008 and deployed successfully.
• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS
• Created Ad-hoc reports for managers using SSRS to immediately have them get access to the reports on the fly and generated reports using SSRS

Technologies: SQL Server 2008/2008 R2, SSRS 2008/2008 R2, Visual Studio 2005, MS Office 2007/2010

Confidential - Hoffman Estates, IL

MS SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data model based on business requirements and provided documentation.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures through SQL Server Agent.
• Created complex SSIS packages using proper control and data flow elements.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Deployed packages on different servers by configuring it.
• Built SSIS packages for processing cubes and dimensions and performed documentation for all kinds of reports, DTS packages and SSIS packages
• Created a number of reports with dynamic parameters accommodating the changing reporting needs of various business users. Also proficient in working with static parameters .
• Extensively worked with MS SQL Server Reporting Services ( SSRS ) 2005 and 2008 and deployed successfully.
• Created Sub-reports, Drill-down reports, Drill-through reports, Summary reports and Parameterized reports in SSRS
• Created Ad-hoc reports for managers using SSRS to immediately have them get access to the reports on the fly and generated reports using SSRS
• Created plan, alerts, schedule in Active Batch to call the SQL agent job which executed the packages.
• Expert in creating MOLAP Warehouse utilizing SQL 2005 Server Analysis Services ( SSAS ) and created cubes with dimensions, facts and hierarchies .
• Experienced in implementing Key Performance Indicator ( KPI ), calculated members, aggregations and partitions in SSAS 2005
• Well versed in using T-SQL for developing Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, SQL joins .
• Involved in all phases of SDLC and successfully completed

Technologies: SQL Server 2008/2005, SSIS 2008/2005, SSRS 2008/2005, SSAS 2008/2005, Visual Studio 2005, MS Office 2007/2003

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Involved in requirement analysis. Direct interaction with the end users and Business Analysts.
• Participated in designing logical and physical data models for database.
• Optimized of Stored procedures using database engine tuning advisor to reduce the execution time.
• Created various indexes on source tables in order to improve Transformation processing timings.
• Used various transformations like Sorting, Merge, Merge join, Fuzzy Grouping, Fuzzy Lookup, Derived column, Multicast etc.
• Generated SSIS packages to upload database from different data sources such as SQL server, Sybase, Excel, Oracle and Access .
• Developed DTS/SSIS package to manage number of Packages in easy manner and to get better performance.
• Created Logging and Configuration files for SSIS packages.
• Created various batch files for the purpose to automate creation of various objects of database.
• Worked on SSRS to generate dynamic reports according to end user requirement and deployed on web-portal.
• Worked on SSRS to generated reports using XML data source .
• Developed various reports like Parameterized, Drill Down, Linked reports using SSRS for business reconciliation and rendered in EXCEL format.
• Involved in SQL Server Cluster and Database Mirroring implementation .
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans .
• Involved in implementation of data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Service

Technologies: SQL Server 2000/2005, MS Office Suite 2003 (Word, Excel, Access, PowerPoint and Outlook), Visio, Erwin, DTS, SSIS 2005, SSRS 2000