PROFESSIONAL SUMMARY:

• Over 10+ years of experience in analyzing data, data modeller and solving real world problems in various domains like Banking/Finance, HealthCare, Marketing and Sales.
• Working knowledge in managing entire data science life cycle with large datasets in various domains and environments.
• Extensive experience in SAS and SQL Coding and Programming, data modeling and data mining.
• Skilled in data management, ETL, and data manipulation, validation and cleaning using various conversation functions and multiple conditional statements.
• Hands on experience in complex querying writing, query optimizing in relation
• Databases including Oracle, T - SQL and SQL Server.
• Experienced in translating business requirements to data science and technical requirements as well as providing analytical feedback.
• Adept in designing visualizations using SAS and Tableau, Dashboards, Business
• Metrics, Operating Statistics and Graphs.
• Proficient in Experimental Design, Sampling, Linear and Logistical Regression and Decision Trees.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical
• Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Strong skills in statistical methodologies such as Hypothesis test and ANOVA.
• Experienced in project management process and procedures, risk analysis and research methodologies.
• Performed data mining, data integration and maintenance database.
• Skilled in analytical and statistical programming languages such as SAS and SPSS.
• Working knowledge in Big Data Ecosystem including Python, and knowledge in NoSQL databases.
• Experienced in business requirements collection methods using Agile, Scrum and Waterfall methods and software development life cycle (SDLC) testing methodologies, disciplines, tasks, resources and scheduling.
• Quick learner with strong interpersonal skills, worked individually as well as a team member while collaborating with others in distributed environments.
• Proficient in Database Design, Development, Normalization, Index, Store ProceduresFunctions and Triggers.

TECHNICAL SKILLS:

Operating System Data Analytics: Windows and Unix/Linux SAS, SQL, ETL, SPSS, SSRS, SSIS

Databases Data Visualization: Oracle, MS SQL Server and MySQL Tableau and Power BI

Languages Big Data: PL/SQL and T-SQL Python and familiar with Hadoop

Design Methodologies Scripting Language: Agile, Scrum and Waterfall SQL and PowerShell

Business Analysis: Statistical and financial modeling

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst/Data Modeler Analyst

Responsibilities:

• Retrieving millions of records of financial, marketing and sales data from relational databases as well as external sources.
• Aggregating and manipulated the batch data collected by a scheduled job to scrape data from various database of different applications.
• Working on data cleaning by ensuring data quality and consistency using SQL and SAS.
• Performing in - house query weekly and monthly basis and writing ad hoc queries, and updating in-house to align new business requirements.
• Performing regression analysis, forecasting, dashboards, business statistics and financial metrics.
• Exploring the data through univariate and multivariate analysis to identify any underlying patterns and associations between the variables.
• Creating Logical/physical Data Model in ERwin and have worked on loading the tables in the
• Data Warehouse.
• Analyzing the huge data from legacy system (Mainframe) to new system (SQL) for migration and identified the gaps.
• Creating all data issue design documents thoroughly and with sufficient logic update.
• Creating reports using proc univariate, proc report, proc reg, proc freq, proc forecast, proc mean, proc format and proc sort.
• Performing results interpretation and writing evidenced based and actionable recommendations.
• Generating data visualizations using SAS and Tableau to report to the management regularly.
• Coordinating with business analysts and subject matter experts for requirements gathering.
• Conducting comprehensive analysis and evaluations of business needs and influenced decisions for different models.
• Collaborating with dev-ops teams for production deployment.

Environment: Oracle 11g, T-SQL, SQL Server 2012, SQL Server 2014, SQL, SAS 9.4, Tableau 9.0 and Python.

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Participated in requirement analysis and meetings with business team to understand the source model.
• Designed the Physical and Logical models using Erwin.
• Expert in Data Analysis Primarily Identifying Datasets, Source Data, SourceMeta Data, Data Definitions and Data Formats.
• Extracted large amount of data administrative and clinical data including data validation and cleaning.
• Worked on Client survey data like data collection, data preparation and feature engineering with SAS, SQL and Excel.
• Performed statistical analysis including ANOVA and hypothesis testing, results interpretations, written actionable recommendations that improved clinic operational activities.
• Performed ad-hoc queries and created dashboard and operating statistics.
• Participated to develop research methodologies for clinical data and study.
• Designed, developed and implemented Workload Analysis for Medical Secretary Role.
• Data interpretation, results synthesized and written evidence-based and actionable recommendations that contributed greatly improve the clinic regular activities and process
• Maintained coordination with team members and prepared presentation.

Environment: SAS 9.3, SQL, T-SQL, SQL Server 2008, SPSS v17 and Excel.

Confidential

Data Analyst/ Data Modeler Analyst

Responsibilities:

• Plan, design, and implement application database code objects such as stored procedures and views
• Provided database coding to support business applications using T-SQL
• Performed quality assurance and testing of SQL server environment
• Developed new processes to facilitate import and normalization, including data files
• Ensured best practices are applied and integrity of data is maintained through security, documentation, and change management
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment
• Interacted with report owners to establish/clarify their requirements and developed report specifications
• Developed SQL Queries, Python, R programs, to fetch complex data from different tables in remote databases using joins, database links and Bulk collects
• Wrote TSQL like Indexes, Views, Stored Procedures and Triggers
• Involved in Database migrations from legacy systems, SQL server to Oracle
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP and OLAP systems
• Generated DDL scripts using Forward Engineering technique to create objects and deploy them into the databases
• Involved in database testing, writing complex SQL queries to verify the transactions and business logic like identifying the duplicate rows by using SQL Developer and PL/SQL Developer
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems
• Worked on Data warehouse concepts like Data Warehouse Architecture, Star schema, Snowflake schema, and Data Marts, Dimension and Fact table Environment: Microsoft, Linux, Oracle 10g / 9i / 8i / 7.x, DB2 7.x / 8.x, SQL Server 2005/2000, MS Access 2000

Environment: Oracle 10g, T-SQL, SQL Server 2012, SQL, SAS 9.3, Python, Excel, Access and Power BI.

Confidential

Senior Data Analyst/Data Modeler

Responsibilities:

• Performed data management, extracted large amount of data from Oracle Database 11, SQL
• Server using PL/SQL, SAS and T - SQL.
• Created SAS datasets using various input styles and options for standard, non-standard and flat data, subsets of data and data manipulating and cleaning using various conversion functions and multiple conditional statements of SAS and SQL.
• Worked on Risk Management team, international and national stakeholders.
• Performed Predictive and Statistical Modeling along with the other aspects of data analytics techniques to collect, explore, and extract insights from data.
• Run in-house query weekly and monthly basis and writing ad hoc queries, and updating in-house queries to align new business requirements.
• Involved in thestudy and understanding of existing system and data architectureand proposed changes necessary to in corporate the new data models.
• Enforced referential integrity in the OLTP data model for the consistent relationship between tables and efficient database design.
• Participated in requirement analysis and meetings with business team to understand the
• Source model.
• Experienced in maintaining the stage and production conceptual, logical, and physical data models along with related documentation for a large data warehouse project. This included confirming migration of data models from Oracle Designer to Erwin and updating the data models to correspond to the existing database structures.
• Performed dashboards, business statistics, operating statistics and financial metrics.
• Created regular reports, including results interpretation and insights, result-based recommendations for immediate measures and strategic decisions.
• Participated and conducted national and international workshops.

Environment: SAS 9.2, SQL, SPSS v17, Oracle, T-SQL, SQL Server 2008, MS Office Suite

Confidential

Research Consultant

Responsibilities:

• Conducted a research study on Small and Medium Enterprise Loan Project of Bangladesh Bank.
• Written ad - hoc queries to extract large amount of data from Oracle and MS SQL Server databases of five commercial banks.
• Manipulated and prepared data using various conversion functions.
• Analyzed data using SAS, SQL and SPSS.
• Performed statistical analysis, evidence-based recommendations and completed research reports.
• Prepared graphical presentations and presented to higher management.
• Updated and maintained performance measurement matrix regularly.
• Provided regular updates and feedback on key indicators.

Environment: SAS 9.3, SQL, SSPS v17

Confidential

Senior Data Analyst

Responsibilities:

• Managed Oracle and MS SQL Server database, maintained and improved data collection, analysis plan and data management policies and procedures.
• Written and developed in - house queries to collect large amount of data weekly and monthly basis from various domains like financial, health,, socio economic, and environment and ensured queries optimizations.
• Transformed data into the right format and corrected faulty data using SQL, SAS, SPSS and Excel.
• Performed Predictive and Statistical Modeling along with the other aspects of data analytics techniques to collect, explore, and extract insights from data.
• Worked with developer team to design, to develop and to implementation various applications in Oracle and SQL Server.
• Performed business requirements and updated performance measurement matrix,
• Performed dashboards, business statistics, operating statistics and financial metrics.
• Performed need based and regular reports, including results interpretation and insights, result-based recommendations for immediate measures and strategic decisions.
• Worked on Risk Management team, international and national stakeholders.
• Trained user and staff on programs and systems.

Environment: SPSS v14, SAS 9.1, Developer 2000, Oracle, SQL Server 2005, MS Office Suite