SUMMARY:

• Data Modeler/Data warehouse Developer/SQL BI Developer with an experience of 5+ years in gathering business requirements through JRD sessions with business analysts, project managers and users.
• Well versed in developing mappings with SSIS, Talend and developing strategies for initial and incremental loads.
• Experience working with data modeling tools like ER - win, ER-Studio and Power Designer.
• Experienced with major databases : Oracle, SQL Server 2008/2012 in large data warehouse (OLAP) environments.
• Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Adept individual with excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: ER-win, ER-Studio, MS Visio

Database Programming: T-SQL, Dynamic SQL, DAX

Development Tools: SSDT, SSMS, BIDS

Integration Tools: SSIS, Talend, Informatica

Analysis Tools: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau, Power BI, Excel Power BI

Source Control & Collaboration Tool: Subversion(SVN), Team Foundation Server (TFS), SharePoint

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler/Data warehouse Developer

Responsibilities:

• Collaborated with business users and project management to gather system specification requirements for the project via JRD sessions.
• Successfully performed dimensional modeling with ER-Studio.
• Contributed in delivering logical/physical data model (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.
• Participated in normalizing tables to remove redundancy and maintain system consistency.
• Monitored, determined and solved issues at SQL/database/server levels.
• Developed stored procedures to analyze customer transaction pattern.
• Created scalar user defined functions to implement constraints on tables.
• Manipulated data in tables through stored procedures and DML triggers.
• Contributed in performance tuning using windows performance monitor and SQL Profiler of SQL Server.
• Integrated data from multiple sources (relational and non-relational) to data mart with SSIS packages.
• Added logical columns to output data in SSIS with derived column transformation.
• Gathered requirements for the creation of data flow processes for the SSIS packages.
• Logged various events to flat files with SSIS log provider for Text files.
• Manipulated various properties at package level and task level to achieve required functionality.
• Developed Power BI dashboards with multiple visualizations.
• Added multiple slicers to filter data and added sync slicers wherever it is necessary.
• Manipulated relationship between tables in Power BI model as required.
• Deployed multiple reports with sub-reports, drill down, drill through and parameter functionality to report server.
• Administrated data driven subscriptions on SSRS Reporting Server to deliver reports based on user needs.
• Improved report latency with well-designed queries and procedures.
• Used TeamForge and JIRA for Project Management.
• Used Subversion (SVN) for the version control and project co-ordination.

Tools & Environment: SQL Server 2012/2016, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, ER-Studio, PowerPoint, Power BI, SQL Profiler

Confidential, Richardson, TX

Data Modeler/ETL Developer

Responsibilities:

• Outlined functional requirements to design the data visualization application by working with other developers in JAD meetings.
• Defined multiple constraints on tables in logical phase of the data modeling life cycle.
• Used Erwin Data Modeler to create Conceptual, Logical and Physical data models.
• Formulated the data migration strategy to populate the data-mart with facts and dimensions.
• Worked in Dimension Data modeling concepts like Star Join Schema Modeling, Snow-Flake Modeling, Physical and Logical Data Modeling.
• Developed SQL code to manipulate large volume of data in tables with batch processing.
• Added new columns to existing tables and populated data to it as per the changed requirements.
• Handled runtime errors with SQL code with try-catch blocks and transactions.
• Created code with respect to security vulnerabilities such as SQL injections.
• Established indexing strategies such as covering indexes, indexed views, and index defragmentation
• Mapped various sources (relational and non-relational) to OLAP destination tables within SSIS.
• Developed SSIS package with for each loop containers to load data from multiple files into SQL table.
• Created XML configuration files for deploying SSIS packages to QA and Integration environments.
• Incorporated error redirections in Data Flow Task to redirect failed and error records for later validation.
• Successfully implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.
• Reviewed, test and deployed the pipelines to the ETL engine.
• Designed reports using complex SSRS expressions to implement conditional formatting, green bar effect etc.
• Wrote MDX queries to retrieve data from cubes and developed reports using SSRS.

Tools & Environment: Oracle 12c, Erwin 9.6, T-SQL, SSIS, SSAS, SSRS, SSDT, Visual Studio, SharePoint

Confidential, Atlanta, GA

ETL/DWH Developer

Key Result Areas:

• Summarized business requirements into technical and functional specifications.
• Maintained referential, domain, and entity integrities for preserving data consistency.
• Created the logical model with Erwin based on business requirements.
• Formulated CTEs and ranking functions to remove duplicate records in OLTP tables.
• Created table valued user defined functions for front end application to retrieve data based on user inputs.
• Modified temporary tables, indexes in order to optimize stored procedures.
• Contributed in performing data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures.
• Managed the automation of the ETL process execution by scheduling a SQL job at specific time of the day.
• Enabled check points for SSIS packages to execute packages from the latest point of failure.
• Optimized reports with modifications to embedded queries or stored procedures.
• Established an interface to organize reports, sort data sources, schedule report executions, and track report history.

Tools & Environment: SQL Server 2008 R2, T-SQL, SSIS, SSRS, Visual Studio, Erwin, MS Excel, TFS

Confidential

Data Analyst

Responsibilities:

• Gathered system specification requirements for the project through JAD sessions.
• Performed normalization and de-normalization of existing tables, thereby enhancing query processing.
• Wrote custom T-SQL stored procedures and triggers to enhance performance, preserve referential integrity, and provide additional application functionality.
• Successfully optimized the performance of queries with modifications to the existing indexes and creation of new indexes.
• Automated report deliveries to multiple recipients with subscriptions in SSRS.
• Assisted in deploying reports in SharePoint integrated mode.

Tools & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSRS, TFS