SUMMARY

• Around 11+ years of experience in Database Querying, Programming, Scripting, Confidential and Analyzing, Designing, Developing and Supporting on various domains like Banking, Financial, Confidential, Mortgage, and Health and also equipped with excellent communication, emotional intelligence, and people skills.
• Strong experience in Data Analyst, Data mining with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modeling, Statistical modeling, Data modeling, Data Visualization, Web Crawling, Web Scraping. Adept in statistical programming languages like R and Python, SAS, Apache Spark Scala, Mat lab including Big Data technologies like Hadoop, Hive, Pig
• Experienced on data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing.
• Exposed and worked in Cloud platforms such as AWS, Azure Data Lakes, MDS (Master Data Services) systems, & Sisense (Data Virtualization tool).
• Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/ Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.
• Experienced in Integrating and migrating the data using BI tools and scripting, and storing the data efficiently.
• Experienced in Data warehouse architecture and designed Star and Snowflake schema, Fact and Dimension Tables, Physical and Logical Data Modell’s. Mapped business processes into technical specifications.

TECHNICAL SKILLS

• Databases: MS SQL Server 2005/2008R2/2012,2014,2016, 2018 Oracle SQL Developer, DB2
• Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Replication, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS), MS Access, Oracle SQL developer, MS Azure
• Reporting Tools: SQL Server Reporting Services(SSRS), Crystal Reports, Qlik View, PowerBI, & Sisense
• ETL Tools: SQL Server Integration Services (SSIS - 2005, 2008, 2012, 2014), Data Transformation Services (DTS), BCP, SQL Server Analysis Service (SSAS), Tableau, Power BI, Informatica Power CenterQuery & Programming Skills
• C,C++, T-SQL, PL/SQL,C#.Net, Python, JSON, JQAL Java Script, Exposed to Linux scripting, Apache Spark Scala: Data Modeler
• MS Visio, ER/Studio, CA Erwin: Web Technologies
• Web Services, XML, HTML, C#.net, Core Java, Web API s: Operating System
• Windows 10/7/NT/2000/2003/XP/, Vista, BizTalk Server: Applications
• MS-Office suite, MS Visual Studio 2005, 2008, 2013, 2015, 2017Exposure: Informatica, Tidal Job Scheduler, Java, Cognos.
• Hadoop/Big Data: Apache Hadoop, HDFS, MapReduce, Pig,Hbase, Hive.

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth

Sr. Data Architect/ Analyst/ Sr. Data Engineer

Responsibilities:

• Involved in Change Control Management and followed the discipline of systematically identifying and controlling change requests of a project from both internal and external sources.
• Data Modeling and Logical/Physical Database Design.
• Developed sophisticated back end data models to support front end application using ER studio and SQL Server.
• Extracted the data from REST API’s using Python as ETL tool.
• Did thorough data analysis, designed and built brand new data warehouse for accounting group (business).
• Modeled SISENSE cubes and designed dashboards with different widgets that represents KPI’s.
• Created enterprise documentation for developed processes and procedures.
• Worked closely with development teams for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Working on AWS Redshift, Hadoop, NoSQL, and Open-Source data management technologies.
• Utilized Apache Spark with Python to develop and execute Big Data Analytics and Machine learning applications, executed machine learning use cases under Spark ML and Mllib.

Confidential, Des Moines, IA

Lead Data Architect/ Modeler/ Sr. Data Engineer

Responsibilities:

• Worked extensively in ETL (SSIS) conversion project that migrates data from Seattle bank to Des Moines bank and gained good knowledge on products such as Derivatives, Loans, Investors and Borrowers.
• Collaborates with cross-functional team in support of business case development and identifying modeling method (s) to provide business solutions. Determines the appropriate statistical and analytical methodologies to solve business problems within specific areas of expertise.
• Generating Data Models using Erwin9.6 and developed relational database system and involved in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Developed cubes using MS Analysis Services (SSAS) and used those Data cubes for Power BI project.
• Part of team implementing REST API’s in Python using micro-framework like Flask with SQLAlchemy in the backend for management of data center resources on which OpenStack would be deployed.

Confidential, Minneapolis, MN

Sr. Data Modeler /Sr. Data Engineer

Responsibilities:

• Worked on data cleaning and reshaping, generated segmented subsets using Numpy and Pandas in Python
• Wrote and optimized complex SQL queries involving multiple joins and advanced analytical functions to perform data extraction and merging from large volumes of historical data stored in Oracle 11g, validating the ETL processed data in target database
• Applied various machine learning algorithms and statistical modeling like decision tree, logistic regression, Gradient Boosting Machine to build predictive model using scikit-learn package in Python
• Developed Python scripts to automate data sampling process. Ensured the data integrity by checking for completeness, duplication, accuracy, and consistency
• Generated data analysis reports using Matplotlib, Tableau, successfully delivered and presented the results for C-level decision makers
• Created and maintained various logins and managed security based on the required access.
• Developed sophisticated back end data models to support front end application using Erwin and SQL Server.

Confidential, Raleigh, NC

­­ Lead BI Developer/Data Engineer

Responsibilities:

• Involved in creating BI reports, data extraction and data loading scripts for different databases and schemas.
• Experience in using collections in Python for manipulating and looping through different user defined objects.
• Generated Python Django forms to record data of online users and used PyTest for writing test cases.
• Used Python to place data into JSON files for testing Django Websites.
• Updated and manipulated content and files by using python scripts.
• Good in script task. Validated the records which was retrieved from the database using c# code
• Worked on Team Foundation Services (TFS) which we use to maintain databases up to date and we also use TFS for storage of updated scripts and also to avoid the data loss.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.