Samuel Collins Email & Phone Number

Charlotte, North Carolina, United States

• Led the business requirement and data analysis for onboarding mTRADE in CIB Whole Loan Trading Program.
• Worked with key business partners on collecting reporting requirements for Mortgage Trading program.
• Met with business team to onboard new General Ledger accounts for the new SOR.
• Created the BRD for Customer Facing Recon which is used for reporting variance.
• Created BRD for Operational Finance Dashboard to include new SOR data related job processing.
• Created Accounting Engine process flow for Journal Entry sub-ledger posting, data quality and consumption.

Charlotte, North Carolina, United States

• Led the key role in data transformation for the card services business.
• Created new data model for moving data from different source systems into a common pool.
• Liaison with business and technology teams to identify functional requirements and build system solution design.
• Analyzed legacy data systems for transformation and designed solutions for integration into the new data model.
• Led the Agile scrum team creating epics and stories for the sprint cycle to meet various business milestones.
• Created use cases from business context to deliver data centric approach in data architecture.Environment: Tableau, Oracle, SQL Server, Teradata, Python, Agile JIRA, Big Data, SharePoint, ServiceNow

Charlotte, North Carolina, United States

Work with the credit data mapping for the data lake integration from upstream source systems and roll out data for downstream business consumers within the bank.

Charlotte, North Carolina Area

• Lead the development and delivery of Enterprise Risk Aggregation for Portfolio Concentration Reporting, SCCL & Credit Risk Reporting, Risk Appetite Metrics, Risk Exposure Reporting and Legal Lending Limit.
• Re-engineered a complex enterprise risk aggregation data warehouse to enable better integration and simplicity of data usage for business.
• Liaison with source and business partners to include data from new System of Records and Lines of Business for enterprise risk aggregation analytics.
• Process data from source systems for Enterprise Risk Aggregation Teradata Warehouse to facilitate data analytics and business reporting.
• Interact with technical and business partners of source systems and create ETL data mapping for risk aggregation and portfolio concentration.
• Lead the Technology Sync meetings with business and source data partners to resolve issues and plan for upcoming production releases.

Worked with multiple clients in the area of Business Intelligence and Data Analytics, leading the Business and Systems integration efforts.Details elaborated below for each Client Project.

Charlotte, North Carolina Area

• Coordinate multiple projects within the Card Services ETL Data Mart group to ensure smooth delivery of Big Data implementation initiatives.
• Served as liaison for various projects like SAS Grid, Fraud, CRH, Autosys and Talend.
• Communicated with ABIT Share services team (ETL, Infrastructure and Database Team) regarding requirement changes/ design updates / outages/ fire drills/ project timelines and delivery status.
• Created and revised project plans in Excel and MS project to track project status.
• Identified issues, escalated when necessary and negotiated resolution to complete tasks in established timelines.
• Collaborated with management and architecture teams in evaluating Hadoop/ Vertica, and initiated POC’s.

Herndon, VA

• Analysis, design, development, testing and defect triage within the data warehouse database.
• Conducted JAD session with business users and technology teams for modifying pool processing logic to exclude loan re-adds when removed from a pool due to collateral maturity.
• Developed PL/SQL procedures for the business requirements.
• Analyzed payment processing logic to include new business rules and triaged new issues for development team.
• Trained new associates onboarding project and walkthrough business users with new system functionalities.Environment: Oracle, Autosys, Toad 9.5, PuTTY, ClearCase 7.1.1.4, ClearQuest, BuildManager.

Groton, CT

• Integrating data from alliance partner sources into the Clinical Aggregation Layer data model.
• Documented changes discussed in meetings and implemented new data mappings to update data model.
• Bridged the gap among various upstream/downstream data points in CAL by creating data flows for interfaces.
• Facilitated to lead discussions that result in consensus and buy-in.
• Extensive experience in Multi-Dimensional Data modeling using Enterprise Architect.Environment: Enterprise Architect 9, Informatica, Autosys, Oracle

Charlotte, North Carolina Area

• Data modeling of Merck animal health data in SQL Server to service MicroStrategy report development.
• Analyzed rebate data in conjunction with EDI data feed to provide insight into key performance metrics.
• Modeled multi-dimensional data framework for building report dashboards in MicroStrategy platform.
• Wrote complex SQL queries using temporary tables for report data validation and data reconciliation.
• Conducted business analysis meetings with animal health divisional managers to encapsulate business data rules.Environment: MicroStrategy 9.2.1, T-SQL, SSIS, SSAS, SSRS, CA ERwin r8, SQL Server 2008 R2, Excel

Charlotte, NC

• ETL development and MicroStrategy business data analysis for the Time Warner Cable digital conversion project.
• Conducted business analysis meetings to design and document business intelligence reporting solution.
• Analyzed data in the data warehouse for MicroStrategy report data mapping to meet client dashboard metric requirements.
• Performed detailed Data Analysis to identify data sources, data gaps, redundancies & anomalies.
• Reviewed the Informatica mappings and workflows for ETL data transformations in the Data Mart.
• Reviewed Informatica IDE and IDQ tools for data profiling.Environment: MicroStrategy 9.2.1, Netezza 6.0.3, Oracle, Informatica PowerCenter 8.6.1, WinSQL 9.0, MDM

Charlotte, North Carolina Area

• MicroStrategy and Informatica business intelligence development in the ECDM project for GCCIBT group.
• Installed and configured MicroStrategy 9.0.2 products for the ECDM project at Bank of America.
• Designed the logical data model and created the MicroStrategy project for ECDM reports.
• Created MicroStrategy Reports and Dashboards for EPI data hub management.
• Reviewed the ETL mappings, sessions and workflows for loading data into EPI target tables.
• Reviewed UNIX shell scripts that send out an E-mail on the success/failure status of process indicating the destination folder where the files are available.Environment: MicroStrategy 9.0.2, Netezza, WebSphere, Oracle.

Columbus, Ohio Area

• Lead the development and delivery of Business Objects reports within Global Finance Technology.
• Led the financial reference data universe/reports design for international demand deposit system and merger projects.
• Architected complex Business Objects universes, reports, dashboards, managed repository and users.
• Participated in fit/gap analysis of functional requirements for SAP and Legacy systems financial account mapping.
• Designed, developed and tested SQL queries to implement complex business rules.
• Worked with business/technology teams to identify data and reporting requirements/issues for Washington Mutual - Bear Stearns merger project and design Reporting solutions.

Raleigh NC

• Build reporting solutions for the BI competence center.
• Designed and developed Base Revenue Report solutions in Business Objects XI-R2 for operational performance analysis.
• Designed Business Objects Universe to link data from heterogeneous source systems.Environment: Business Objects XI-R2, Oracle 10g, Autosys, Toad, UNIX, Windows.

Charlotte, North Carolina Area

• Handle reinsurance application systems, reporting and data requirements for Underwriting, Claims and Operations department.
• Recognized for outstanding internal customer service in 2006 for consistently delivering projects in line with CMMI quality standards meeting IT goals and milestones.
• Established Universe design applying multi-dimensional data modeling concepts to address transparent retroceded business reports that track policy movement and claims data distributed in multi-tier levels governed by.
• Scheduled daily control and monthly perpetual ledger data reconciliation reports to satisfy Sarbanes-Oxley requirements.
• Eliminated statement processing errors by implementing Oracle stored procedures and packages to validate business rules. Created sub-ledger data exception reports to analyze the root cause, initiated a project, formed.
• Developed the Admin Rules system using Java technologies including XML, XSLT, Eclipse and Weblogic.

Reading, Pennsylvania Area

• Lead the design and development of real-time application systems and reports for Carpenter Steel melting shop.
• Engineered data extraction, transformation and loading to facilitate data flow between SQL Server and Oracle database using database pipelines. This made real-time application data available to analytical systems.
• Designed and developed cross-tab reports to analyze and alert variances in melting shop furnace material mixing.Environment: Oracle, SQL Server, PL/SQL, T-SQL, Access, PowerBuilder

Greater Pittsburgh Area

Managed and mentored the software development teams working for multiple client projects across North America.Screened and hired developers to form teams for meeting various client requirements.

Led development of the integration module for Infoway ISP project and created GUI for Oracle database user administration.

Hamamatsu, Japan

Led an application development team in Japan to work in collaboration with CSK technical team for Yamaha Corporation.

Naperville, Illinois

Responsible for TMS-5 telecommunication product re-design and development for Lucent Technologies.

Thane, Mumbai Area, India

Developed modules for an integrated enterprise-wide computerization project for DGP Windsor Limited.

Chennai Area, India

Worked on Master Data Module that was part of enterprise-wide computerization product for Lakhsmi Vilas Bank.

Mca, Computer Applications

Activities and Societies: .Selected for government sponsorship of "Technical Japanese for MCA students" program.Chosen as MCA Class.

B.Sc., Mathematics

Activities and Societies: Petty Officer Cadet in National Cadet Corps, Project Coordinator in National Social Service, Coordinator for.

Hsc, Higher Secondary Certificate

Activities and Societies: Was part of the School Basket Ball Team.Won third prize in inter-school cultural competition held at Don Bosco.